Generated Agents and Modules
When Create agent per database is enabled, each database creates an agent using the format [Agent prefix]Azure SQL <server>/<database>. In consolidated mode, every module is sent to Target agent, and module names include the server and database. Agent autodisable mode creates agents with agent_mode set to 2; otherwise, the value is 1.
Filters use exact, case-insensitive matches rather than regular expressions. Separate multiple values with ;.
The entities file preserves previously discovered resources. A stored entity that no longer appears is counted in resources_vanished and generates only Azure SQL Connection with value 0. When the re-scan interval expires, the cache is rebuilt without comparison against previous entities.
Always-created modules
| Module | Type | Unit | Description |
|---|---|---|---|
Azure SQL Connection |
generic_proc |
Value 1 for a discovered database and 0 for a vanished entity. |
|
Database online |
generic_proc |
Value 1 when the status is Online or Ready; otherwise 0. |
Performance modules
| Module | Type | Unit | Aggregation |
|---|---|---|---|
CPU percent |
generic_data |
% |
Average |
DTU consumption percent |
generic_data |
% |
Average |
Physical data read percent |
generic_data |
% |
Average |
Log write percent |
generic_data |
% |
Average |
Sessions percent |
generic_data |
% |
Average |
Workers percent |
generic_data |
% |
Average |
Storage modules
| Module | Type | Unit | Aggregation |
|---|---|---|---|
Data space used GB |
generic_data |
GB |
Average |
Data space used percent |
generic_data |
% |
Average |
Data space allocated GB |
generic_data |
GB |
Average |
Connection modules
| Module | Type | Unit | Aggregation |
|---|---|---|---|
Successful connections |
generic_data |
Count |
Total |
Failed connections |
generic_data |
Count |
Total |
Blocked by firewall connections |
generic_data |
Count |
Total |
Tempdb and XTP modules
| Module | Type | Unit | Aggregation |
|---|---|---|---|
Tempdb data size MB |
generic_data |
MB |
Average |
Tempdb log size MB |
generic_data |
MB |
Average |
Tempdb log used percent |
generic_data |
% |
Average |
XTP storage percent |
generic_data |
% |
Average |
Deadlock modules
| Module | Type | Unit | Aggregation |
|---|---|---|---|
Deadlocks |
generic_data |
Count |
Total |