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.
A Spotlight on Foglight – How Spotlight Users can ease their way into Foglight
This webcast covered:
- Perspectives from a consultant who supports customers using both Spotlight and Foglight
- Why Foglight’s architecture is different and, in some cases, better.
- Initial Approaches – where to find the things that Spotlight user’s love the most.
- Heat Map, Real Time View, Custom Views, Alarm Templates, Reports and Quick Tips
- Where Foglight can extend capabilities found in Spotlight
- Workload Analysis, Change Tracking, Compare, Dashboarding and Reporting and Cross Platform Database Monitoring
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
