The Top Commands tab shows Analysis Services query level collection and any MDX, DAX, DMX, and XMLA commands that have run longer than one second. All of the like queries have been rolled up and grouped together so you can see their total impact. Drill down to see individual queries and group by event class to do discovery on the grid data.
| Columns | Descriptions |
|---|---|
| Event Class | The event class of the associated event. Additional Information: For more information, see the SQL Server Event Class Reference MSDN article. |
| Text Data | Associated text data captured for the event. |
| Parameters | Contains the parameters for parameterized queries and commands associated with the query event. |
| Application | Name of the client application that created the connection. |
| Database | Name of the database for the associated event. |
| Host | Name of the target where the associated event is running. |
| Login | The Windows or SQL Server account associated with the event. |
| Duration | The amount of time taken by the associated event. |
| CPU | The amount of CPU time (in milliseconds) used by the event. |
| CPU % | The percentage of CPU time used by this event, in relation to any other Top Commands events that are shown in the grid. |
| FE Time | Time spent by workload on the Formula Engine. |
| SE Time | Time spent by workload on the Storage Engine. |
| Processing Time | Time spent by workload processing. |
| SQL Query Time | Time spent by workload in SQL queries. |
| SE Non-cache Ops | Number of Non-cache Storage Engine operations. |
| SE Cache Ops | Number of Cache Storage Engine operations. |
| Callbacks | Applies to Tabular mode only. Provides the number of callbacks from the VertiPaq Storage Engine to the Formula Engine associated with the query. |
| Measure Groups | Provides a count of the number of Measure Groups accessed by the query or command. |
| Partitions | Provides a count of the number of Partitions accessed by the query or command. |
| Agg Hits | Applies to Multidimensional mode only. Provides a count of the number of Aggregations accessed by the query. |
| Dimensions | Provides the dimensions of the query hierarchy. |
| Attributes | Provides a count of the number of Attributes accessed by the query. |
| Rows Sent | Provides a count of the number of rows returned by the query. |
| Processing Rows | Provides a count of the number of rows processed by the command. |
| Errors | Error number of a given event. |
| Error Text | Contains the text data associated with the error event. |
| Reads | The number of logical disk reads performed by the server on behalf of the event. |
| Reads % | The percentage of bytes read by this event, in relation to any other events that are shown in the Top Commands tab. |
| Writes | The number of physical disk writes performed by the server on behalf of the event. |
| Writes % | The percentage of bytes written by this event, in relation to any other events that are shown in the Top Commands tab. |
| Start Time | Time the event started. |
| End Time | Time the event ended. |
| Information | Additional data captured about the event. |
Right-click on any query, and Jump To the dashboard. You can also Jump To > Calendar to see what else is running at the same time, or Jump To > Runtime Stats to see if there are any outliers on runtime.
Additional Information: For more information about Disk Activity and Disk Space, see the Disk Activity and Disk Space topics.
| Name | Description |
|---|---|
| Jump To > | Jumps to the corresponding tab. |
| Calendar |  |
| Dashboard |  |
| SSAS Usage Totals |  |
| Runtime Stats |  |
| Add/Edit Notes | Adds or edits a note to the query. |
| Hide | Hides the query from the list. |
| Copy > | Copies the cell, row, or entire query to the clipboard. |
