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:
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.
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.
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 firstname.lastname@example.org
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?