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