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 (more than 50 instances) should consult the Foglight for SQL Server Hardware Sizing Guide.
Foglight for SQL Server requires WMI access for monitoring Windows OS metrics on the various SQL Server dashboards. Ensure that the WMI and Remote Registry services are started prior to creating the agents and are available throughout the monitoring process.
Notes:
| Operating System/ SQL Server Version |
SQL Server 2000 | SQL Server 2005 | SQL Server 2008 | SQL Server 2008 R2 | SQL Server 2012 | SQL Server 2014 |
| 32-bit | ||||||
| Windows Server 2003 | v, SQL PI | v, SQL PI | v, SQL PI | |||
| Windows Server 2008 | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | |
| 64-bit | ||||||
| Windows Server 2003 | v, SQL PI | v, SQL PI | v, SQL PI | |||
| Windows Server 2008 | v, SQL PI | v, SQL PI | v, SQL PI | |||
| Windows Server 2008 R2 | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | |
| Windows Server 2012 | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | ||
| Windows Server 2012 R2 | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | ||
| Windows 7 | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | ||
| Windows 8 | v, SQL PI | v, SQL PI | v, SQL PI | v, SQL PI | ||
Notes:
Foglight includes a licensing capability that restricts access to those features that are defined in the license. Any Management Server installation requires a license that grants access to server-specific parts of the browser interface and the features associated with them. Foglight cartridges are also license-protected. While some cartridges are covered by the base Foglight license (such as Foglight Agent Manager cartridges and the Foglight for Infrastructure), others may require an additional license.
Foglight for SQL Server is covered by the base Foglight license that allows cartridges to be installed. The SQL Performance Investigator extension requires a dedicated license.
To activate a trial or a purchased commercial license:
The Foglight for SQL Server release package contains the following:
Refer to the Managing SQL Server Database Systems Getting Started Guide for installation instructions, available at http://documents.quest.com/foglight-for-sql-server/5.7.5.1/foglight-for-sql-server-getting-started-guide/. Determine your environment hardware requirements using the Hardware Sizing Guide, available at http://documents.quest.com/foglight-for-sql-server/5.7.5.1/foglight-for-sql-server-hardware-sizing-guide/.
This section provides a list of references which address the most commonly faced issues relating to remote connectivity, allowing for easy troubleshooting using the vendor's information knowledgebase:
