Orion.APM.SqlQueryAlert
SolarWinds Information Service 2020.2 Schema Documentation
This entity presents SQL query information. Used in alerting.
Inheritance
Access control
everyone
Properties
| Name | Type | Summary | Access Control |
|---|---|---|---|
| ID | System.Int64 | The unique integer representation of SQL query. | everyone |
| ApplicationID | System.Int32 | The unique integer representation of application. | everyone |
| SqlBbDatabaseID | System.Int32 | The unique integer representation of SQL database. | everyone |
| ServerQueryHash | System.Guid | The SQL query GUID. | everyone |
| QueryText | System.String | The string value that contains the SQL query text. | everyone |
| LastExecutionTime | System.DateTime | The date and time of the last SQL query execution. | everyone |
| LastPollTime | System.DateTime | The date of poll for SQL query. | everyone |
| PlanCount | System.Int32 | The integer value that contains the SQL query plan count. | everyone |
| ExecutionCount | System.Int64 | The integer value that contains the SQL query execution count. | everyone |
| CpuTime | System.Int64 | The long value that contains the SQL query CPU count. | everyone |
| PhysicalReadCount | System.Int64 | The long value that contains the physical reads count. | everyone |
| LogicalReadCount | System.Int64 | The long value that contains the logical reads count. | everyone |
| LogicalWriteCount | System.Int64 | The long value that contains the logical writes count. | everyone |
| AvgDuration | System.Int64 | The long value that contains the average query duration. | everyone |
| Spid | System.Int32 | The integer value that contains the SQL server process ID. | everyone |
| Login | System.String | The string value that contains login user name. | everyone |
| Host | System.String | The string value that contains SQL server name. | everyone |
| Status | System.Int32 | The status of an SQL query. | everyone |
| DisplayStatus | System.String | The status of an SQL query. | everyone |
Target Relationships
| Name | Type | Notes |
|---|---|---|
| SqlApplicationAlert | Orion.APM.SqlServerApplicationAlert | Defined by relationship Orion.APM.SqlServerApplicationAlertHostsSqlQueryAlert (System.Hosting) |
| SqlQuery | Orion.APM.SqlQuery | Defined by relationship Orion.APM.SqlQueryAlertReferencesSqlQuery (System.Reference) |