Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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 SQL Server Profiler to collect performance data. You use SQL Server Management Studio (SSMS) to analyze the data.
Does this meet the goal?
geekeek1
4 years, 5 months ago