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.
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.
The left side displays Windows metrics for the monitored server.
The right side displays SQL server metrics for the monitored instance.
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 SQL Sentry.
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.
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.
QuickTrace is SQL Sentry's version of profiler, but without the overhead. You can specify how long QuickTrace runs, and whether it collects statement events. Additionally, QuickTrace can be made as a response to an event.