Base type: System.Entity
Summary: This entity presents SQL query information.
| Name | Type | Notes |
|---|---|---|
| QueryID | System.Int32 | The unique integer representation of SQL query. |
| ApplicationID | System.Int32 | The unique integer representation of application. |
| ServerQueryHash | System.Guid | The SQL query GUID. |
| ServerQueryHandle | System.Byte[] | Original SQL query handle (needed for DPOA module integration). |
| SqlDatabaseID | System.Int32 | The unique integer representation of SQL database. |
| 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. |
| Spid | System.Int32 | The integer value that contains the SQL server process ID. |
| 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. |
| 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. |
| TimeStamp | System.DateTime | The date of poll for SQL query. |
| DetailsUrl | System.String | URL to SQL query details page. Used in alerting. |
| DisplayName | System.String | The string representation of query name. |
| DisplayName | System.String | |
| Description | System.String | |
| InstanceType | System.Type | |
| Uri | System.String | |
| InstanceSiteId | System.Int32 | Default='0'. |
| SqlQueryAlert | Orion.APM.SqlQueryAlert | Defined by relationship Orion.APM.SqlQueryAlertReferencesSqlQuery (System.Reference) |
| Database | Orion.APM.SqlDatabase | Defined by relationship Orion.APM.SqlDatabaseQueries (System.Hosting) |