You are mastering the company database, and managing 20 SQL Server 2005 computers which
are operated by other administrators that are asked to meet company service level agreements
(SLAs) on querying response time .Some of the method on controlling query response times on
the servers should be told for these administrators. Which is the correct answer?

A.
You should create a query that searches the sys.dm_db_partition_stats dynamic management view (DMV). Then distribute this search to the administrators.

B.
You should develop an XML schema which includes the event and column names of the query response times, which should be captured in SQL Server Profiler.

C.
You should develop SQL Server Profiler templates, which contain query start times and end times. Then distribute these templates to the database

D.
You should teach the administrators to use System Monitor Control Tool