Base type: System.Entity
Summary: This entity presents SQL query information. Used in alerting.
| Name | Type | Notes |
|---|---|---|
| ID | System.Int64 | The unique integer representation of SQL query. |
| ApplicationID | System.Int32 | The unique integer representation of application. |
| SqlBbDatabaseID | System.Int32 | The unique integer representation of SQL database. |
| ServerQueryHash | System.Guid | The SQL query GUID. |
| QueryText | System.String | The string value that contains the SQL query text. |
| LastExecutionTime | System.DateTime | The date and time of the last SQL query execution. |
| LastPollTime | System.DateTime | The date of poll for SQL query. |
| PlanCount | System.Int32 | The integer value that contains the SQL query plan count. |
| ExecutionCount | System.Int64 | The integer value that contains the SQL query execution count. |
| CpuTime | System.Int64 | The long value that contains the SQL query CPU count. |
| PhysicalReadCount | System.Int64 | The long value that contains the physical reads count. |
| LogicalReadCount | System.Int64 | The long value that contains the logical reads count. |
| LogicalWriteCount | System.Int64 | The long value that contains the logical writes count. |
| AvgDuration | System.Int64 | The long value that contains the average query duration. |
| Spid | System.Int32 | The integer value that contains the SQL server process ID. |
| Login | System.String | The string value that contains login user name. |
| Host | System.String | The string value that contains SQL server name. |
| Status | System.Int32 | The status of an SQL query. |
| DisplayStatus | System.String | The status of an SQL query. |
| DisplayName | System.String | |
| Description | System.String | |
| InstanceType | System.Type | |
| Uri | System.String | |
| InstanceSiteId | System.Int32 | Default='0'. |
| SqlApplicationAlert | Orion.APM.SqlServerApplicationAlert | Defined by relationship Orion.APM.SqlServerApplicationAlertHostsSqlQueryAlert (System.Hosting) |
| SqlQuery | Orion.APM.SqlQuery | Defined by relationship Orion.APM.SqlQueryAlertReferencesSqlQuery (System.Reference) |