Microsoft
70-450 · Question #8
You administer a SQL Server 2008 instance. You plan to design a monitoring solution for the instance to monitor object usage statistics. The solution must identify a list of first 10 objects for…
The correct answer is A. Use dynamic management views. Background info:
Design and implement an optimized monitoring strategy
Question
You administer a SQL Server 2008 instance. You plan to design a monitoring solution for the instance to monitor object usage statistics. The solution must identify a list of first 10 objects for each of the following components:
- Most frequently executed stored procedures and functions
- Long running Transact-SQL statements
You need to implement the monitoring solution to minimize performance effect by using the least amount of administrative effort. What should you do?
Options
- AUse dynamic management views.
- BUse a System Monitor counter log.
- CUse a client-side SQL Server Profiler trace.
- DUse a server-side SQL Server Profiler trace.
How the community answered
(34 responses)- A74% (25)
- B15% (5)
- C9% (3)
- D3% (1)
Explanation
Background info:
Topics
#DMVs#object usage statistics#stored procedure monitoring#performance monitoring
Community Discussion
No community discussion yet for this question.