Chat now with support
Chat with Support

Foglight for Azure SQL Database (Cartridge) 7.2.1 - User Guide

Installing and Configuring Agents Using Foglight for Azure SQL Database Administering Foglight for Azure SQL Database Reporting Reference
Overview of Collections SQL Performance Investigator Metrics
Active Connections Active Time Active Time per Execution Active Time Rate Always On Average CPU Percent Average DTU Percent Average Memory Usage Percent Average SQL Response Time Average XTP Storage Percent Average Data IO Percent Average Log Write Percent Backup Recovery Blocked Sessions Connections CPU Limit CLR Wait CLR Wait per Execution CLR Wait Rate CPU Time CPU Time per Execution CPU Time Rate CPU Wait CPU Wait per Execution CPU Wait Rate Cursor Synchronization Database Replication Deferred Task Worker Distributed Transaction DTU Limit Elapsed Time Executions External Procedure Full Text Search Governor Wait Governor Wait per Execution Governor Wait Rate Granted Memory Hosted Component Inactive User Connections I/O Bulk Load I/O Completion I/O Data Page I/O Wait I/O Wait per Execution I/O Wait Rate Idle Time Internal Cache Latch Latch Buffer Latch Savepoint Latch Wait Latch Wait per Execution Latch Wait Rate Lead Blockers Lock Bulk Update Lock Exclusive Lock Intent Lock Schema Lock Shared Lock Update Lock Wait Lock Wait Rate Lock Wait per Execution Log Buffer Log Other Log Synchronization Log Wait Log Wait per Execution Log Wait Rate Log Write Logical Reads Logical Reads per Execution Max Degree of parallelism Max DTU Percent Max Session Percent Max Workers Percent Memory Wait Memory Wait per Execution Memory Wait Rate Network HTTP Network I/O Network IPC Network Mirror Network Wait Network Wait per Execution Network Wait Rate OLEDB Provider Full Text Other Miscellaneous Other Wait Other Wait per Execution Other Wait Rate Parallelism Wait Percent of Total Plan Recompilations Physical Reads Physical reads per Execution Preemptive Wait Preemptive wait per Execution Preemptive Wait Rate Remote Provider Wait Remote Provider wait per Execution Remote Provider Wait Rate Row count Service Broker Synchronous Task Wait Time Percent Writes Writes per Execution XTP Log write Wait XTP Miscellaneous Wait XTP Procedure Wait XTP Transaction Wait XTP Wait XTP Wait per Execution XTP Wait Rate
Glossary

Administering SQL Performance Investigator

The SQL Performance Investigator view in the Administration dashboard allows you to enable and disable SQL PI monitoring for selected agents.

Reporting

Foglight for Azure SQL Database enables generating reports about various aspects of the selected database. This section provides information on how to generate the various reports, as well as a brief description of each report.

 
* 
NOTE: For detailed information regarding the use and configuration of reports, see Foglight User Guide > Working with Reports.

For details, see these topics:

•
Generating Reports for a Foglight for Azure SQL Database

Generating Reports for a Foglight for Azure SQL Database

Generating Reports for a Foglight for Azure SQL Database
To generate reports for a selected database:
1
Go to Dashboards > Reports.
2
Click Run a Report.
The Run Report dialog box opens.
3
On the first screen, Select Template, Go to All Templates.
4
Select the requested report.
5
Click Next.
6
Select the requested time range.
7
Select the database or for which the report will be generated.
8
Click Next.
9
Assign a name for the report.
10
Select the report format (PDF, Excel or XML).
11
Use the Email Recipients field to type the name of the report’s recipients.
12
Click Finish.
The report generation process starts. Upon successful completion of this process, the Report Generated Confirmation dialog box opens.
13
Click Download Now to download the file.

Open the file using a relevant program for the selected format.

Reference

This section describes the collections that are used with monitored Azure SQL databases:

•
Overview of Collections
•
SQL Performance Investigator Metrics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating