Management Studio Reports – Part 1 – Finding the Reports

Management Studio Reports – Part 1 – Finding the Reports

  • Comments 7

Did you know that there is a set of pre-made reports in Management Studio that can help database administrators gather information in many common areas?  There are reports for CPU, memory, disk, sessions, queries, transactions, and more baked right into Management Studio.  You can access these reports in SQL Server 2005 and SQL Server 2005 SP1 by following these steps:

  1. Open Management Studio
  2. Highlight a server instance or database in Object Explorer
  3. Open the Summary Page (F7)
  4. Click on the Reports button

There are multiple reports available per Object Explorer node type.  If you highlight a server instance in Object Explorer, you will have a different set of reports to view than if you highlight a database.

This blog post is the first in a multi-part series where I will describe some of my favorite reports and how they can be used.  See the attached video (SSMS Reports - 1.WMV) for a quick demo of how the Management Studio Reports can be used with SQL Server 2005 and Microsoft Excel 2007.

If you’d like, I’ll try to get clearance to post the Reporting Services (.RDL) files so you can design your own reports to run in your SQL Server 2005 Reporting Services environment.

-Paul

Attachment: SSMS Reports - 1.wmv
Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post
  • It would be great to see the .RDL file released or someway for us to customize these reports.

    Sanchan
  • What a great tool!  Is there a documented way to automate specific reports via SQL Agent jobs?  I'd prefer not to install Reportign Services to achieve this.  This would really benefit system DBAs that have to provide metrics on hundreds of severals on a regular basis.
  • PaulMest,

    I agree with Sanchan. These reports can give a DBA a very good snapshot of what occurs at both the instance and database level. Being able to produce customized reports based on your examples would be very nice. The ability to produce PDF files is a nice touch.

    Basketball? Isn't that where a bunch of tall guys in floppy shorts run up and down a court throwing a ball around?
  • Paul,

    I'd like to see the .rdl files used.  Also, if you're able to disclose how your preventing them from displaying in the Report Manager I'd be interested in that as well.  I don't see them in the Catalog table in the ReportServer database.

    Thanks,
    jP
  • Wow!  I didn't even realize those reports were in Mgt Studio until I saw this blog.  They will save loads of time.

    Posting the RDL's is a great idea because then we can integrate those reports into other custom system management dashboards.

  • Paul,

    Please forgive this intrusion.  I have two servers each running SQL 2005 SP2 release 2050.  On one server I see the reports option in the context menu returned by right clicking on server or database objects.  On the other server the Reports option is not available.  I've tried searches in BOL the net and forums and have not found how to make this option available in SSMS.  I apprecaite any guidance you may provide.  My email is bburke@cedonline.com

    Thanks,

    Bill

  • Hi Guys,

    While I was at Tech Ed they said there was a place we could download reports for SSMS.  Can someome tell me where these are?

Page 1 of 1 (7 items)