Database cartridges allow you to monitor your database instances. But you can boost the power of your monitoring by adding one or more of these features.
Configuring Foglight’s ServiceNow Integration
This webcast covered:
- Quick refresh on how to add monitored assets to a Foglight Service
- How to set Alarm Filters to be designated as Incidents in ServiceNow
- Understand the corresponding remediation and synchronization between Foglight Alarms and ServiceNow Incidents
Where can Service Definitions be used in Foglight?
This webcast covered:
We explored several use cases where service definitions (and underlying UI queries) address customer needs.
The following use cases were discussed:
1a - Only send email on host alarms for a subset of hosts. Keep alarms active for all hosts.
1b - Only send email for a subset of alarms on a subset of hosts.
2a - Only apply a rule to alert on a subset of SQL databases (eg. DB backup alarm).
2b - Send failure alerts to developers for only their jobs.
3 - Show a dashboard with details on the "jobs I care about." Status indicator for alarms + table of job details.
4 - Show a dashboard with green/yellow/red status of instances, etc. that "belong to me."
Show URL and explain auth token approach to sharing.
Enhance your Database Monitoring with Host Monitoring
This webcast covered:
- How to better determine if host performance is applying pressure to the database and contributing to poor database performance
Moving from Performance Analysis to Performance Investigator
This webcast covered:
- The differences between Foglight Performance Analysis and Foglight Performance Investigator
- Key considerations for anyone making the move
Distinct and Helpful Features of Database Cartridges
This webcast covered:
- Databases dashboard tips and tricks
- Steps to define alert thresholds and email notifications for database alarms
- How to create and use User-Defined Collections
Using Utility Cartridges to Extend Your Monitoring
This webcast covered:
- Web Monitor Cartridge: Monitor the availability and response time of various websites.
- Net Monitor Cartridge:Monitor the connectivity and health of network connectivity between various end points.
- Log Monitor Cartridge:Monitor log entries in Windows Event Logs, or any text based log file.
Continuous Monitoring, the DBA, and Fitting into the DevOps Culture
This webcast covered:
- Enable DBAs, application development teams, and other stakeholders to share the same consistent performance metrics and understand the environment health at any given time
- Correlate database and infrastructure changes to the actual application performance
- Compare performance and configuration across production and test environments
Monitoring Beyond the Database
This webcast covered:
- vCenter/ESX plugin to gather virtual metrics within SQL Server and Oracle
- Included OS monitoring with Database monitoring
- Review of Webmonitor, Netmonitor and Logfilter capability
- Special Technology Preview - upcoming Docker, Kubernetes and Swarm monitoring
Finding and tuning problematic queries with Foglight Expert
View webcast here
This webcast covered:
- Foglight alarms that can actively notify you of current and emerging query issues
- Screens that help you isolate resource-consuming statements
- Analytics to quickly discover the databases, users, and applications with which the statements are associated
- View the query plans to help determine bottlenecks
- Initiate a tuning session and be provided rewrite alternatives
Capacity Planning & DB Expansion Pack
View webcast here
This webcast covered:
- Understanding your current database workload using specific metrics and baselines
- Setting up and organizing your plan for capacity management by scheduling monthly and /or quarterly reports
- Getting additional functionality by using the DB Expansion Pack
Expand your database monitoring coverage with Foglight for Cross Platform databases
This webcast covered:
- Adding new instances to be monitored in Foglight for Cross Platform Databases
- Identifying and addressing Postgres Locks Waiting that can become problematic Deadlock transactions
- Optimizing Postgres Query Performance
- Managing Postgres Disk Space Usage
- Leveraging Foglight’s PostgreSQL Administration capabilities
Introduction to the Foglight REST interface
This webcast covered:
- What is a REST interface and how is it implemented in Foglight
- Introduction to the Foglight Data Topology
- Connecting to Foglight from a Python program
- Developing a simple data extract program using the REST interface
- Troubleshooting REST interactions with Foglight
