Top Commands

The Top Commands tab shows Analysis Services query level collection and any MDX, DAX, or XMLA commands that have run longer than one second. All 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.

SentryOne Top Command

SentryOne Top Command B

ColumnsDescriptions
Event Class The event class of the associated event. For more information, see the SQL Server Event Class Reference MSDN article.
Text DataAssociated text data captured for the event.
ParametersContains the parameters for parameterized queries and commands associated with the query event.
ApplicationName of the client application that created the connection.
DatabaseName of the database for the associated event.
Host Name of the target where the associated event is running.
LoginThe Windows or SQL Server account associated with the event.
DurationThe amount of time taken by the associated event.
CPUThe 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 TimeTime spent by workload on the Formula Engine.
SE TimeTime spent by workload on the Storage Engine. 
Processing TimeTime spent by workload processing. 
SQL Query Time Time spent by workload in SQL queries. 
SE Non-cache OpsNumber of Non-cache Storage Engine operations. 
SE Cache OpsNumber of Cache Storage Engine operations. 
CallbacksApplies to Tabular mode only. Provides the number of callbacks from the VertiPaq Storage Engine to the Formula Engine associated with the query.
Measure GroupsProvides a count of the number of Measure Groups accessed by the query or command.
PartitionsProvides a count of the number of Partitions accessed by the query or command.
Agg HitsApplies to Multidimensional mode only. Provides a count of the number of Aggregations accessed by the query.
DimensionsProvides the dimensions of the query hierarchy. 
AttributesProvides a count of the number of Attributes accessed by the query.
Rows SentProvides a count of the number of rows returned by the query.
Processing RowsProvides a count of the number of rows processed by the command.
ErrorsError number of a given event.
Error TextContains the text data associated with the error event.
ReadsThe 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.
WritesThe 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 TimeTime the event started.
End TimeTime the event ended.
InformationAdditional 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.

For more information about Disk Activity and Disk Space, see the Disk Activity and Disk Space topics. 

NameDescription
Jump To >Jumps to the corresponding tab.
CalendarSentryOne BI Sentry Calendar
DashboardSentryOne BI Sentry Dashboard
Top CommandsSentryOne BI Sentry Top Commands
SSAS Usage TotalsSentryOne BI Sentry SSAS Usage Totals
Runtime StatsSentryOne Jump To Runtime Stats
Action LogsSentryOne Jump To Action Logs
Add/Edit NotesAdds or edits a note to the query. 
HideHides the query from the list. 
Copy >Copies the cell, row, or entire query to the clipboard.