This project is read-only.

DMVStats 1.0 - A SQL 2005 DMV Performance DW

Rating:        Based on 1 rating
Reviewed:  0 reviews
Downloads: 2140
Released: Jun 29, 2007
Updated: Jul 2, 2007 by thomasda
Dev status: -not yet defined by owner-

Recommended Download

Documentation DMVStats.doc
documentation, 506K, uploaded Jun 30, 2007 - 1081 downloads

Other Available Downloads

Source Code dmvstats
source code, 518K, uploaded Jun 30, 2007 - 1059 downloads

Release Notes

DMVStats 1.0

The download file is 'dmvstats'. Refer to dmvstats.doc for details, descriptions and user guide.

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 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.

Tom Davidson & Sanjay Mishra
SQL Server Customer Advisory Best Practices Team

Reviews for this release