A SQL Server 2005 Dynamic Management View Performance Data Warehouse
Microsoft SQL Server 2005 provides Dynamic Management Views (DMVs) to expose valuable information that you can use for performance analysis. DMVstats 1.0 is an application that can collect, analyze and report on SQL Server 2005 DMV performance data. DMVstats does not support Microsoft SQL Server 2000 and earlier versions.Main Components
The three main components of DMVstats are:
• DMV data collection
• DMV data warehouse repository
• Analysis and reporting.
Data collection is managed by SQL Agent jobs. The DMVstats data warehouse is called DMVstatsDB. Analysis and reporting is provided by means of Reporting Services reports.
For more details, refer to the file attachment DMVStats.doc.Tom Davidson & Sanjay MishraMicrosoft SQL Server Customer Advisory Best Practices Team
Best Practices Team link: http://technet.microsoft.com/sqlserver/bb331794.aspx