DPA comes with many out of the box metrics for Azure SQL Database, and here are some additional ones that you can add to your DPA installation.
The attached script contains a query for each of the metrics below. Next to each metric will be the word "single value" or "rate" which is associated with the Type of Metric Query:
CPU Metrics
- CPU Core Count
Disk Metrics
- Page Reads / sec
- Page Writes / sec
Memory Metrics
- Buffer Cache Size
- Log Bytes Flushed / sec
- Page Life Expectancy
- Plan Cache Size
- SQL Compilations
- SQL Re-Compilations
Sessions
- Batch Requests / sec
- Transactions / sec
TempDB
- Free Space %
- Free Space MB
- Current Size MB
- Log File Free Space %
- Log File Free Space MB
- Log Files Current Size MB
- Version Store Size
Here is an example definition for the Batch Requests per second metric:
