Custom Administrative Reports – Part II
The "Performance Dashboard" is a good example of custom administrative reports – reports you can use from the Management Studio to administer the SQL Server. Of course you can use other custom reports in the Management Studio. For ex. Simon Sabin wrote the SQL 2005 Management Studio version of the good old Enterprise Manager Task Pad (http://sqlblogcasts.com/blogs/simons/archive/2007/03/28/Update-to-the-taskpad-custom-report.aspx )
Note:
If you haven’t downloaded the Performance Dashboard you can find it in this link : http://www.microsoft.com/downloads/details.aspx?familyid=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en
I would like to contribute two reports:
Server Properties – server and database properties. When one of the properties is not Microsoft’s best practice it turns red.
Maintenance Plan history – the history of the full backup, index rebuilding, consistency checks and database shrink. When you use the Enterprise Manager history / Management Studio you can only see the history of databases which are part of the maintenance plan. But what if the database doesn’t have a maintenance plan at all and its indexes never rebuilt? You won’t see that database in the history!!
In my reports you will.
The reports I wrote could be used on SQL Server 2000 / 2005.
How to use it?
Save the attached RDL files on your machine. You should create a folder for the reports. For ex.
"C:\Program Files\Microsoft SQL Server\90\Tools\CustomReports".
Right click on an SQL Server node in the Object Browser (the node can be SQL Server 2000 as well), click on Reports, Custom Reports, and browse to the location of the RDL file called ServerProperties (it has a link to the other report).
This is it, the Management Studio can run the report, and you don’t need Reporting Services server for that.
It is just a first version so please let me know if you found any bugs.
I hope others will share their reports / queries with us.
Cheers,
Itay Braun
Premier Field Engineer - SQL Server
Microsoft Services - UK
E-Mail: itayb@microsoft.com
Mobile: +44-796-928-9996
Veni Vidi Fixit