The SQL Server DBA Dashboard is a reporting tool to help DBAs and programmers quickly identify resource usage and what is using those resources. The dashboard does this through a series of graphs and reports which are integrated into SQL Server Management Studio. Navigation to all reports can be done with just a couple of clicks from a central dashboard (displayed below).
From this main dashboard you can quickly get detailed reports by clicking on the graphs and hyperlinks. These detailed report help you monitor and identify those resources intensive queries and processes. By using the reports DBA and programmers can quickly narrow down what they should be working on to improve performance.
When resources reach threshold limits the Performance Counters change colors to help administrators quickly determine what resources are under pressure. Threshold hold values are configurable to meet the needs of your environment.
Comments