Installing and Configuring Agents
Using Foglight for Azure SQL Database
Viewing the Databases Dashboard
Selecting an Instance to Monitor
Foglight for Azure SQL Database Overview Dashboard
SQL Performance Investigator (SQL PI)
Azure SQL Activity Drilldown
Administering Foglight for Azure SQL Database
Opening the Databases Administration Dashboard
Reviewing the Administration Settings
Customizing Alarms for Foglight for Azure SQL Database Rules
Reporting
Reference
Introducing the Alarms View
Modifying Alarm Settings
Configuring Email Notifications
Cloning Agent Settings
Reviewing Rule Definitions
Defining Connection Details
Administering SQL Performance Investigator
Overview of Collections
Glossary
Usability
Query Store
Query Store Top SQLs
Version Info
Resource Stat
Wait Statistics
Database Connections Summary
Database Replication
Database Storage
Database Recommendations
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
Alarm
Authentication
Calibration
Cartridge
Client Machines
CPU Usage
CPU Wait
DataFlow
Deadlock
Disk Transfer Time
Disk Utilization
DiskPerf
Dispatcher
Drilldown
DTU
Elastic Pool
External Procedures
Foglight Agent Manager
Foglight Management Server
General purpose
I/O Wait
Kernel Memory
Kernel Mode
Kill
Lock Wait
Log Buffer Wait
Logical Reads
LRU
LSN
Metric
Network Wait
OLTP
Other Wait
Paging
Panel
Physical Reads
Process
Random I/O
Recompile
Referential Integrity
Relational Data Engine
Schema Locks
Severity
Single database
SPID
Spinner
Threshold
Transaction
Unused Space
vCore
Administering SQL Performance Investigator
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
|
1 |
|
2 |
Click Run a Report. |
|
3 |
|
5 |
Click Next. |
|
8 |
Click Next. |
|
11 |
Use the Email Recipients field to type the name of the report’s recipients. |
|
12 |
Click Finish. |
|
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: