APS Sentry Overview

Download: Interested in learning more about APS Sentry pricing or downloading a trial? Visit the SentryOne APS Sentry product page.

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:

Top Graphs

Graph Description
Processor Time
Data Movement Read/Write Buffers

Middle and Bottom Graphs

GraphDescription
Distribution Activity Displays a graphical representation of the distribution activity for a selected metric across databases within your environment in milliseconds. Each color on the graph represents an individual database in your environment. 
Node ActivityDisplays a graphical representation of the node activity for a selected metric across the databases within your environment in milliseconds. Each color on the graph represent an individual database in your environment. 
Data Movement CPU (ms)
Displays a graphical representation of data movement CPU activity across the databases within your environment in milliseconds. Each color on the graph represents an individual database in your environment.
Elapsed Time (ms)Displays a graphical representation of elapsed time of data movement across the databases within your environment in milliseconds. Each color on the graph represents an individual database in your environment.
Rows ProcessedDisplays a graphical representation of the rows processed across the databases within your environment in milliseconds. Each color on the graph represents an individual database in your environment. 
MB ProcessedDisplays a graphical representation of MB processed across the databases within your environment. Each color on the graph represents an individual database in your environment.
MB/SecDisplays a graphical representation of MB processed per second across the databases within your environment. Each color on the graph represents an individual database 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.