Default reports in SSMS

2

July 13, 2017 by Kenneth Fisher

As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are the most common place to get the information we need but every now and again it’s nice to get an organized/pretty view. To that end, you can write your own reports or you can use the default reports that Microsoft makes available through SSMS. There are reports at the Server, Database and Agent level.

Server

DefaultReports

Database

DefaultReport2

Agent

DefaultReport3

It’s easy enough to get to them. Just right click (ServerName, DBName, or Agent) -> Reports -> Standard Reports -> Select your report. Then once you start using them your recent reports will start showing up under the reports menu.

DefaultReport4

2 thoughts on “Default reports in SSMS

  1. […] Kenneth Fisher talks about the default reports built into Management Studio: […]

  2. […] Time for some homework again. I know Pass Summit is this week so you may be a bit busy but regardless this is an important one. Did you know that SSMS (SQL Server Management Studio) has a bunch of built in reporting? […]

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 6,758 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013