70-450 · Question #40
You are a professional level SQL Sever 2008 Database Administrator. A monitoring solution should be designed for the instance to have object utilization statistics monitored. A list of first 10…
The correct answer is D. To accomplish the task, dynamic management views should be utilized. Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Important: Dynamic management views and functions return internal, implementation-specific state data…
Question
You are a professional level SQL Sever 2008 Database Administrator. A monitoring solution should be designed for the instance to have object utilization statistics monitored. A list of first 10 objects should be identified by the solution for each of the following two components:
- Most frequently executed stored procedures and functions
- Long running Transact-SQL statements
The monitoring solution should be implemented with minimum performance effect, and the least amount of administrative effort should be utilized. Which action will you perform to accomplish the task?
Options
- ATo accomplish the task, a System Monitor counter log should be utilized.
- BTo accomplish the task, a client-side SQL Server Profiler trace should be utilized.
- CTo accomplish the task, a server-side SQL Server Profiler trace should be utilized.
- DTo accomplish the task, dynamic management views should be utilized.
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C4% (1)
- D86% (24)
Explanation
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Important: Dynamic management views and functions return internal, implementation-specific state data. Their schemas and the data they return may change in future releases of SOL Server. Therefore, dynamic management views and functions in future releases may not be compatible with the dynamic management views and functions in SQL Server 2008. There are two types of dynamic management views and functions: - Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server. - Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.
Topics
Community Discussion
No community discussion yet for this question.