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