Documentation forSQL Sentry

APS Sentry Overview

 

Data Movement Dashboard

View important Microsoft APS activity, including key CPU metrics, elapsed time, rows processed, and MB/sec processed. The dashboard also helps you visualize the correlation of that activity against the compute nodes and the associated distributions.

Using the APS Sentry Data Movement Dashboard allows you to identify data movement activity quickly and easily. Zoom-in on key periods of activity, go back in time to any specified time, and Jump To other features within the product. The Data Movement Dashboard contains the following charts that provide an at a glance view of your environment:

Graph Description
Distribution Activity  Displays a graphical representation of the distribution activity for a selected metric across compute nodes within your environment in milliseconds. Each color on the graph represents an individual compute node in your environment. 
Node Activity Displays a graphical representation of the node activity for a selected metric across the compute nodes within your environment in milliseconds. Each color on the graph represent an individual compute node in your environment. 
Data Movement CPU (ms)
Displays a graphical representation of data movement CPU activity across the compute nodes within your environment in milliseconds. Each color on the graph represents an individual compute node in your environment.
Elapsed Time (ms) Displays a graphical representation of elapsed time of data movement across the compute nodes within your environment in milliseconds. Each color on the graph represents an individual compute node in your environment.
Rows Processed Displays a graphical representation of the rows processed across the compute nodes within your environment in milliseconds. Each color on the graph represents an individual compute node in your environment. 
MB Processed Displays a graphical representation of MB processed across the compute nodes within your environment. Each color on the graph represents an individual compute node in your environment.
MB/Sec Displays a graphical representation of MB processed per second across the compute nodes within your environment. Each color on the graph represents an individual compute node in your environment. 
Note:  Selecting a graph on the bottom pane automatically updates and displays the selected metric data on graphs in the middle pane. For example, select the bottom pane graph Rows Processed to show detail data for Distribution Activity: Rows Processed and Node Activity: Rows Processed in the top pane graphs.  

Distributed Queries Tab

Get details about any live or historical requests and the associated request steps across the APS environment. APS Sentry lets you set query collection thresholds based on duration, and displays the executed request, client, application, login, label, and resource class, along with pertinent performance metrics. For more information about the Distributed Queries tab, see the Distributed Queries article.

Loads, Backups, and Restores Tab

View information about both in-process and historical events across your APS environment through the Loads, Backups, and Restores grid. For more information, see the Loads, Backups, Restores article. 

Health Alerts Tab

Get critical information about the overall health of your APS environment through Advisory Conditions, which display the description, type, severity, and current/previous value of outlying conditions.

Event Calendar

View of all your Microsoft APS activity in a convenient calendar format. Use the Event Calendar to help you visualize how specific activities affect one another, and jump to run-time performance graphs to see specific query performance trends.