You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 instance should be managed. 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 and 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?
A.
To accomplish the task, a System Monitor counter log should be utilized.
B.
To accomplish the task, a client-side SQL Server Profiler trace should be utilized.
C.
To accomplish the task, a server-side SQL Server Profiler trace should be utilized.
D.
To accomplish the task, dynamic management views should be utilized.