Phills Philosophies: SQL Server 2005 Dynamic Management View Performance Data Warehouse

Wednesday 18 July 2007

SQL Server 2005 Dynamic Management View Performance Data Warehouse

http://www.codeplex.com/sqldmvstats

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:

Post a Comment

Subscribe to: Post Comments (Atom)

Rain Radar : Loop
Satellite : Loop

Phill is

And the Internet is

Disclaimer

The opinions and practices expressed herein are my own personal opinions and practices and do not represent the view of my employer, or any associated company, product or manufacturer in anyway. Any mis-understanding/mis-reading/mis-using of content posted herein is entirely at the viewer/users peril.