Database Reference
In-Depth Information
To view the collected Data Collector Sets from PERFMON, stop the collection and right-click
on collector set to choose Load Report to display the collected information for that instance:
Also, the SQLNexus tool helps to load and analyze the performance data collected by the
SQLDiag tool, which reduces the amount of time that we spend to manually analyze the
collected data.
There's more.
SQL Server 2008 R2 has an internal feature called Management Data Warehouse that will
perform the data collection and store the information as a data warehouse with extensive
reporting functionality.
See Also
F
The
Implementing
Management
Data
Warehouse
features
recipe highlights the
relevant steps and automated methods to implement a performance baseline of
data platform.
Search WWH ::
Custom Search