Historical lock analysis – Resolve SQL Server concurrency issues in record time with historical reviews of blocking-lock scenarios. The lock analysis is part of the dimensional drilldown workflow, simplifying lock investigations.

Integrated reporting – Receive targeted, built-in reports. With easy-to-use wizards, you can define, customize, generate, schedule and deliver reports on system health, performance, trends, changes and a variety of other topics and data points.

Specifications

Before installing Foglight for SQL Server, ensure that your system meets the hardware and software requirements detailed in Foglight System Requirements and Platform Support Guide. Customers running large deployments (above 50 instances) should consult with the Foglight for SQL Server sizing assistant.

Foglight for SQL Server requires WMI access for monitoring Windows Operating system metrics on the various SQL Server dashboards. Ensure that the WMI and Remote Registry services are started prior to creating the agents and throughout the monitoring process. Firewall usage requires taking further steps to ensure connection to WMI, as detailed in the known issues section under Connection to WMI.

Supported Platforms

The operating system platforms and SQL Server versions supported by the Foglight for SQL Server agent on Foglight 5.5.2 are shown below:

Supported Web Browsers

The Foglight user interface works with standards-compliant web browsers. The following table lists the web browsers that have been tested and validated for use with this release of Foglight.