Administering Foglight for Azure SQL Database

You use the Databases Administration dashboard to set options for collecting, storing, and displaying data about monitored Azure SQL databases.

This section covers the following key areas:

Reviewing the Administration Settings

Use the Databases Administration dashboard to set options for collecting, storing, and displaying data, which apply to all of the currently selected agents. Click a category of settings on the left (for example: Connection Details) to open a view containing related settings on the right.

The metrics defined on the Databases Administration dashboard apply to all of the agents that were selected before opening the Administration dashboard. As a result, the same unit of measure and aggregation value for display are enforced for all currently selected agents.

To view the full list of selected agents, click Selected Agents button at the upper right corner of the screen. To change the list of agents to which the metrics apply, exit the Databases Administration dashboard, select the required agents, and re-open the dashboard.

If the settings vary between the selected agents (for example: one agent uses the measurement unit kilobyte, while another uses megabyte), the fields that contain non-identical values are displayed as empty and marked with an Inconsistent Values () icon. Changes made to settings should be saved before selecting another category of settings.

To save changes made in an Administration dashboard view:

  1. In the Database Administration dashboard, select a category of settings from the left-hand panel.
  2. Make changes to settings as necessary.
  3. Click Save changes at the bottom of the view. If you attempt to exit the view without saving changes, a Warning dialog box prompts you to confirm your action.

Customizing Alarms for Foglight for Azure SQL Database Rules

Many Foglight for Azure SQL Database multiple-severity rules trigger alarms. To improve your monitoring experience, you can use alarm templates to customize when alarms are triggered and whether they are reported. You can also set up email notifications. For more information, refer to Working with Alarms.

Defining Connection Details

Use the Connection Details category to define global connection settings, which apply to all instances and hosts selected in the view. You can enable user-defined collections and set VMware connection details. The following sections instructs how to define the connection settings for monitored Azure SQL databases.

Defining the Connection Settings for the Monitored Azure SQL databases

The Connection Details view contains a table that displays all the agents that were selected before entering the Databases Administration dashboard.

To define the connection settings for the requested agents:

  1. Select the check boxes to the left of the agents for which uniform credentials are to be set. To cancel the selection, click Select None and select again.
  2. Click Set Credentials. The Edit Instance Credentials dialog box opens.
  3. Use the Connection Details section to enter or accept the default port (1433).
  4. Use the Specify Login Credentials section to select the type of authentication, specify the user name and the password used for connecting to the Azure SQL Database.
  5. Click Set to proceed to the next stage of validating the database’s connectivity.

Validating Connectivity and Starting to Monitor the databases

After setting the default credentials for the host, these newly created credentials can now be used by the wizard to attempt to log in to the databases.

To validate the databases’ connectivity:

  1. Click Test connection. The Verifying Connectivity progress bar appears. At the end of this process, any connectivity issues are listed in the Status column of the database table. When the connection is successful, the Status column displays the status message Validated, which indicates that the database connected successfully and the specified Azure SQL user has the required permissions. If the connection failed verification, the Status column displays one of several connectivity status messages. The messages, causes, and appropriate responses are:
    • Invalid username/password — check the credentials and try again.
    • Incorrect port— check if the SQL Azure port is correct and try again.
    • Wrong Database Credentials — modify the login credentials.
    • Insufficient Privileges — grant the user the privileges required for connecting to the database, by clicking the status Insufficient Privileges. The Insufficient Privileges dialog box opens. Use this dialog box to specify a Server Admin user with sufficient privileges. Select the type of authentication. Type a Server Admin user and password, and then click Grant privileges. If the Server Admin credentials entered were incorrect, the column displays the status Wrong Sysadmin credentials. After correcting the mistakes that resulted in the connectivity failure, click again Validate connectivity.
  2. Click Validate connectivity on the status bar.
  3. Click Save Changes. The Applying Modified Settings progress bar appears.