Return
-
Title
Monitoring Azure Virtual Machines running Windows and SQL Server -
Description
Can the SQL Server cartridge be used to create an agent that connects to a Windows based Azure virtual machine running SQL Server? -
Cause
The Foglight SQL Server cartridge can be used to monitor Azure Management virtual machines running Windows with SQL Server.
-
Resolution
As a minimum, an Azure-based Virtual Machine running Windows and SQL Server require the following configurations in place for a Foglight SQL Server and Infrastructure agents to be able to monitor the instance and machine.
Two Endpoints configured to use the same public and private port configured in the Azure management console.
- An endpoint for the SQL Server port used by the instance (by default 1433)
- An endpoint for the WinRM port 5985 if using unencrypted WinRM communications
In the Windows Firewall on the virtual machine
- Add an inbound rule for WinRM port 5985
- Add an inbound rule for the SQL Server instance port (by default 1433).
For OS monitoring, the Azure-based Windows virtual machine should be configured to use WinRM or WMI as per KB article 185163.
Additional firewall rules and endpoints may be required for the SSL WinRM connections or the use of WMI (see KB 85747).
-
Attachments
-
Additional Information
The Azure SQL Database service, the customer can use Foglight for SQL Azure - 5.5.8.6.SP2. Foglight for SQL Azure is developed for SQL Azure version 10.0.50.x to version 11.0.1467.26, residing on Microsoft Azure. The Azure Managed Instance, the customer can try to use SQL Server Cartridge 5.9.3 and up.