You need to collect data from the following two sources:
* The performance counters of the operating system
* Microsoft SQL Server events
You must analyze the two datasets side-by-side by using a single tool.
Solution: You use dynamic management views and Data Collector Sets (DCSs) in Performance Monitor to collect performance data. You use SQL Server Management Studio (SSMS) to analyze the data.
Does this meet the goal?
Currently there are no comments in this discussion, be the first to comment!