GET monitor/{id}/topquerylist?sqlInfoId={sqlInfoId}
Retrieves a list of top queries information for the specified SqlProfileId and SqlInfoId
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| id | System.Guid | Required | |
| sqlInfoId | System.Guid | Required |
Body Parameters
None
Response Information
Resource Description
System.Collections.Generic.IEnumerable`1[Epic.Data.Models.TopQueryItem]
| Name | Description | Type | Additional information |
|---|---|---|---|
| CreationTime | System.DateTime | None | |
| LastExecutionTime | System.DateTime | None | |
| TextData | System.String | None | |
| ExecutionCount | System.Int64 | None | |
| TotalCpu | System.Int64 | None | |
| TotalReads | System.Int64 | None | |
| TotalWrites | System.Int64 | None | |
| TotalPhysicalReads | System.Int64 | None | |
| TotalDuration | System.Int64 | None | |
| LastCpu | System.Int64 | None | |
| LastReads | System.Int64 | None | |
| LastWrites | System.Int64 | None | |
| LastPhysicalReads | System.Int64 | None | |
| LastDuration | System.Int64 | None |