SQLCAT (Customer Advisory Team) has announced the release of DMVStats. It produces a database (calling it data warehouse is very ambitious) that contains snapshots caught through Dynamic Management Views (DMV) of SQL Server 2005. You can see database behavior from a new and useful perspective. It’s an interesting idea and these kinds of applications are a good change to use many of the “real-time” features of Analysis Services 2005.
The next steps should be:
- An Analysis Services cube to analyze data
- A Data Mining analysis to analyze relationship between events
The second one might be an utopia today… but this is the first necessary step in that direction.
Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/07/14/dmvstats-released.aspx