Maintaining a healthy database environment requires diligent SQL Server monitoring across your infrastructures. Vendor-provided tools don’t offer the depth and breadth of SQL Server performance monitoring that you need to quickly diagnose and resolve performance issues, or anticipate future issues based on historical analysis.
Quest® Foglight® for SQL Server provides the clarity needed to quickly and easily detect, diagnose, resolve and report on performance issues — wherever, whenever and however they occur. Foglight ensures optimal database performance with comprehensive database, storage and virtualization monitoring and advanced workload analytics — providing a wealth of information at a fraction of the impact of conventional collection methods. Its intuitive, web-based interface allows DBAs to assess enterprise-level performance at a glance. And with a single installer, Foglight for SQL Server is easy to deploy so you can be up and running in no time — with minimal footprint and without agent overhead drag on monitored hosts.
In conjunction with Foglight for SQL Server, Foglight SQL Performance Investigator is a valuable add-on for SQL Server monitoring that allows you to:
With regard to query performance tuning, as part of its SQL Server monitoring capabilities, Foglight identifies long-running or resource-intensive queries as tuning candidates, integration of Quest's SQL Optimizer helps you find sub-optimal code for further tuning. Then, it automates that tuning with query rewrites, index advice and optimization.
Foglight analyzes wait events and contention problems, and provides alerts and advisories that allows the DBA to tune the database to process workloads more efficiently.
Yes, in addition to SQL Server monitoring, Foglight monitors MySQL and MongoDB, along with 9 other types of databases at this time. You simply license Foglight for the database instances you wish to monitor. There are out-of-the-box dashboards available for licensed DBMS types. Each monitored instance appears in the Databases Global View so you can launch your database performance investigations from that single location.
Elevated credentials are not required for the Foglight user to view monitoring information. Only the Foglight collection mechanism requires certain privileges for the DBMS as Foglight executes lightweight queries. Foglight stores those credentials securely in the product's own "lockbox" mechanism.
There are two main reasons for checking performance counters during SQL Server monitoring:
Although they have some overlap, these two reasons allow you to easily choose a number of data points to monitor. This operational monitoring checks for general resource usage and you can use the data for trending purposes. You can monitor the performance counters without leaving Foglight.
It was crucial that we got reliable SQL Server performance monitoring. We didn't have satisfactory analysis tools, and we needed automation options.Hans-Jörg Bütler Head of Database Operations Read Case Study
We’ve found Foglight to be invaluable when it comes to monitoring databases and giving us a heads up before things happen.Lead DBA Read Case Study
When your company has to respond in less than 10 seconds to an inquiry about a claim or else pay a stiff fine, you’d better have a tool that monitors everything affecting SQL Server performance.DBA Manager Read Case Study
Spotlight has enabled us to do more with existing staff and has prevented the need for headcount increases.Matt Andrew Database Manager Read Case Study