Wednesday, 18 July 2007

SQL Server 2005 Dynamic Management View Performance Data Warehouse

Basically a bunch of stored procedures and SQL Agent jobs to gather info and a series of reports to show the data.

Quite interesting is the use of a report as a management interface where you can add/remove databases and disable SQL Agent Jobs. Sort of makes the static report into an application.

No comments: