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?
A.
Use dynamic management views.
B.
Use a System Monitor counter log.
C.
Use a client-side SQL Server Profiler trace.
D.
Use a server-side SQL Server Profiler trace.