SSMS 2017: Built-in Performance Dashboard Reports


SQL Server Performance Dashboard Reports are used to monitor and resolve performance issues in your Database Server. They are generally targeted towards a Database Administrator, and enabling them to quickly identify any performance bottlenecks in the system, gather diagnostic information that can potentially help to resolve the issue. All the information is retrieved from Dynamic Management Views.

Before SSMS 17.2, it required a separate download and install process for the Performance Dashboard Reports. With the new SSMS 17.2, the Performance Dashboard are now embedded as a built in Standard Report.

To access the reports, Right Click on the Database –> Go to Reports –> Go to Standard Reports –> Performance Dashboard

Performance Dashboard Report

Common performance problems that the dashboard reports may help to resolve include:
– CPU bottlenecks (and what queries are consuming the most CPU)
– IO bottlenecks (and what queries are performing the most IO)
– Index recommendations generated by the query optimizer (missing indexes)
– Blocking
– Latch contention

By clicking on the respective links below, you can gather detailed information and recommendation for your workload.

Performance Dashboard SSMS 2017

 

SSMS provides a number of standard database level reports out of the box for performance monitoring and troubleshooting purpose. The best thing about these reports are that it encapsulates all the complexity behind generating them. The information is extracted from the DMVs, however you need not execute T-SQL queries to get this information.

Read more about the Performance Dashboard Reports here.

One thought on “SSMS 2017: Built-in Performance Dashboard Reports

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s