70-450 · Question #7
You administer a SQL Server 2008 infrastructure. You discover that an instance experiences performance degradation for the following reasons: - Excessive CPU usage - Server processes paging…
The correct answer is A. Extended Events. Is a broad error-handling system that can correlate data between SQL server, the OS, and other Events from SQL Server can be collected, then passed elsewhere (a "target") for reporting or Resource governor is for limiting resource consumption. The DTA (Database Tuning Advisor)…
Question
You administer a SQL Server 2008 infrastructure. You discover that an instance experiences performance degradation for the following reasons:
- Excessive CPU usage
- Server processes paging
- Deadlocks
You need to design a monitoring solution that can provide data, including detailed deadlock information, to monitor and troubleshoot performance issues. You want to achieve this goal by using the minimum amount of administrative effort. What tool should you use?
Options
- AExtended Events
- BResource Governor
- CDatabase Engine Tuning Advisor
- DPerformance Monitor (SYSMON)
How the community answered
(31 responses)- A74% (23)
- B13% (4)
- C10% (3)
- D3% (1)
Explanation
Is a broad error-handling system that can correlate data between SQL server, the OS, and other Events from SQL Server can be collected, then passed elsewhere (a "target") for reporting or Resource governor is for limiting resource consumption. The DTA (Database Tuning Advisor) makes index recommendations. PERFMON monitors operating system and sql server counters.
Topics
Community Discussion
No community discussion yet for this question.