You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 instance. In Domain.com there are 15 servers which are used by other administrator at the
company. However, they need to comply with the company service level agreements (SLAs) on
querying response time. Some of the administrators need information of the method on controlling
query response times on the servers.
What should you do?
A.
You should consider teaching them to use the System Monitor Control Tool.
B.
You should consider creating a query that searches the sys.dm_db_partition_stats dynamic
management view (DMV) and distribute this search to them.
C.
You should consider developing SQL Server Profiler templates, which contain query start times
and end times and distribute these templates to the administrators.
D.
You should consider developing an XML schema which includes the event and column names
of the query response times. That can be captured in SQL Server Profiler.