Performance Analysis Features
Performance Analysis allows you to gather and display detailed information about your monitored servers within your environment. Performance analysis provides ease of access through a variety of tabs.
Note: Available tabs and features vary by product (i.e. SQL Sentry vs. Win Sentry vs. BI Sentry).
The Dashboard provides a graphical representation of the monitored server activity through a variety of graphs. Color coded graphs distinguish between what's used by the instance versus any other processes.
Note: The information shown on each tab is relevant to the time shown on the toolbar. See how the server looked at a given date or time by selecting the desired time in the Start and End drop-down boxes. Select Sync to synchronize all the tabs within the same time frame.
The left side displays Windows metrics for the monitored server.
The right side displays SQL server metrics for the monitored instance.
Note: If you are running in Limited access mode, you can only view the instance level metrics.
The Processes tab presents a list of processes that are running on your monitored server. Metrics related to the resource utilization of these processes is also shown.
The Disk Activity tab displays information about the data and log files on your server. This tab displays the latency for reads and writes from files on your disk, and the latency from the system to the disk controllers.
The Disk Space tab displays information about the size of the files on your disks, and the free space on your disks. Additionally, this tab provides detailed information about Data and Log files (auto growth settings, number of VLFs, etc).
The Top SQL tab displays potentially problematic queries and procedures running on your monitored instance. Top SQL also provides a look at the execution plan diagrams and history of queries and procedures captured by SentryOne.
The Indexes tab provides a view of the collected table and index information according to the settings and schedules chosen when enabling the fragmentation manager solution.
The AlwaysOn tab displays information about configured availability groups.
Blocking SQL displays a view of the blocking events that were collected on your server.
Note: Blocking SQL provides different versions of the block depending on which SPIDs were being blocked, and which SPID was the head blocker at the time.
The Query Plans tab lists all plans collected for Top SQL events for the specified date range. This provides a detailed chronology of all query plan changes, so you can go back to any point in time to see when a plan change may have led to a query performance problem.
Deadlocks displays a grid of the SPIDs that owned a lock on a resource, as well as SPIDs waiting for a resource. This is a graphical representation, that allows you to easily identify the steps leading to the deadlock.
Quick Traces is SentryOne's version of profiler, but without the overhead. You can specify how long Quick Trace runs, and whether it collects statement events. Additionally, Quick Trace can be made as a response to an event.