Custom SQL Server Administrative Reports - Part I

Custom Administrative Report 

As you know Microsoft just released set of reports as part of the “Performance Dashboard”. These reports could be used on SQL Server 2005 SP2 only.

http://www.microsoft.com/downloads/details.aspx?familyid=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en

The "Performance Dashboard" is a good example of custome administrative reports. Of course you can  use other custom reports in the Management Studio.

Report 1 - Last Full Backup for each database 

The report attached show a list of the databases and their last full backup date. If the last full backup was more than 7 days ago then the database name turns red, else it turns green.

The query excludes the following databases: Northwind, pubs, tenpdb, AdventureWorks, AdventureWorksdb, model.

How to use it?

Save the RDL file 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.

This is it, the Management Studio can run the report, you don’t need Reporting Services server for that.

 Soon I’ll upload another report about database properties.

It is just a first version so please let me know if you found any bug.

I hope others will share their reports / queries with us.

What Next?

Report 2 - databases best practice (when something is not on the "best practice mode" the databases turn red with explanation what's wrong)

Cheers,

Itay Braun

Premier Field Engineer - SQL Server

Microsoft Services - UK

E-Mail: itayb@microsoft.com

Mobile: +44-796-928-9996

Veni         Vidi         Fixit