This guide provides configuration instructions, conceptual information and instructions on how to use the Foglight for Azure SQL Database cartridge. It describes the dashboards included with the cartridge and how they are used for collecting monitoring data from the entire relational database management system, as well as the cartridge’s interaction with and support of additional services and modules, such as replication and virtualization.
This guide is intended for Azure SQL Database administrators and for any users who want to know more about monitoring Azure SQL Databases through Foglight for Azure SQL Database, and the steps required for discovering and configuring the Azure SQL agent. It is also meant for those users who want to learn about the methods used for configuring and applying user-defined settings.
For installation pre-requisites, permissions, and information necessary to determine your environment�s hardware requirements, see the Foglight for Databases Deployment Guide.
Foglight for Azure SQL Database monitors the Azure SQL Database activity by connecting to and querying the Azure SQL Database. The agents provided monitor the Azure SQL Database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the Azure SQL agents. They allow you to determine any potential bottleneck in database performance.
Starting to work with a Foglight for Azure SQL Database cartridge requires upgrading to the current version of both the cartridge and the Foglight Agent Manager that runs the cartridge.
2 |
3 |
Navigate to the Agent Status dashboard and deploy the Azure SQL agent package to the existing Foglight Agent Manager hosts. |
Foglight for Azure SQL Database provides a graphic, intuitive method for creating and configuring multiple agents, which can be used instead of Foglight’s default method for creating agents and editing their properties using the Agent Administration dashboard.
IMPORTANT: When running Foglight for Azure SQL in a Federation architecture, neither the creation nor the administration of agents can be accomplished from the central Foglight Management Server (the Federation Master). These two tasks should be carried out from the stand-alone Management Servers (the Federated Children). |
1 |
2 |
a |
Click the Agent Manager Host <agent manager> link located at the top of the Azure Database Connection section. |
a |
Server Name — Specify the host name. |
c |
5 |
Select between SQL Server Authentication and Azure Active Directory (AD) Authentication. Specify the username and password to be used for monitoring the Azure SQL Database in the Login Credentials section. |
NOTE: The SQL Performance investigator requires an additional license, check the licensing information via Click for Licensing Information. |
8 |
Optional To enable SQL Performance Investigator, select SQL PI in the Monitoring Extension section. The SQL PI Repository dialog is displayed. Select the Agent Manager on which the SQL PI |
c |
If no SQL PI repository exists on the selected Agent Manager, the SQL PI Repository Settings |
NOTE: To use gMSA authentication for connections to the PI Repository, select Local User in the Authentication drop-down. This requires that your FMS and Agent Manager are configured to run as a Windows Service logged on with the gMSA account. The gMSA account requires access to the SQL instance. |
d |
If the given SQL PI repository user does not have sufficient privileges, the Insufficient Privileges dialog will be displayed. Enter an admin user and password, and then click Grant Privileges. |
9 |
Click Monitor. |
10 |
When the installation completes successfully, the Monitoring Initialized Successfully dialog box appears. Click Add another Database or Finish to exit. |
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center