Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.9.7.20 - Release Notes

Supported platforms

Foglight for SQL Server supports monitoring the following platforms:

•
Supported SQL Server versions:
•
SQL Server 2005 through 2019
•
SQL Server 2017, 2019 for Linux
•
Amazon RDS for SQL Server 2012, 2014, 2016, 2017
•
Azure SQL Managed Instance
•
Supported Operating Systems:
•
All Operating Systems supported by Microsoft® SQL Server

 

* 
NOTE:  
•
Foglight for SQL Server also supports the Express and Developer editions of Microsoft® SQL Server.
•
Virtualization monitoring requires installing the VMware tools service on the monitored VM.
•
SQL Server on AWS VM (IaaS) is supported and can be monitored as long as the Instance port is opened and the OS is configured as described in: Configuring Windows Remote Management (WinRM).
•
For the Amazon RDS for SQL Server, only Standard and Enterprise version are supported.

Final Browser Support Notice

Support for Microsoft® Internet Explorer® 8, 9, and 10 has been discontinued in this Foglight release.

Microsoft ended the support for these browsers on January 12, 2016. For more information, visit https://support.microsoft.com/en-us/lifecycle?p1=13418.

Troubleshooting

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 knowledge base:

•
To verify TCP/IP connectivity for SQL statement collections, Management Studio (SSMS) cannot be used as other protocols may be leveraged. Instead, verify connectivity using a UDL as detailed here: https://support.microsoft.com/kb/308075/.
•
To verify the WMI connectivity using a Microsoft Windows built-in utility, see https://technet.microsoft.com/en-us/library/cc180684.aspx.
•
To troubleshoot WMI access permissions, see http://blogs.technet.com/b/askperf/archive/2007/08/14/wmi-troubleshooting-permissions.aspx.
•
For information about WMI connectivity from Windows Server 2003/Vista and later versions, see http://msdn.microsoft.com/en-us/library/aa822854(VS.85).aspx.
•
For WMI troubleshooting tips and techniques, see http://msdn.microsoft.com/en-us/library/aa394603(VS.85).aspx.
•
For PI troubleshooting tips: exclude the SQL PI repository directory (named Infobright™) from real-time scanning (for example, Antivirus software). For a virtual machine, the CPU and memory allocations must be reserved.

Product licensing

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:
1
On the navigation panel, under Dashboards, click Administration > Setup > Manage Licenses.
2
Click Install.
3
In the Install License dialog box, click Browse.
4
In the file browser that appears, specify the location of the license file.
5
In the Install License dialog box, click Install License.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating