PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are a database administrator for AIOTestKing.com. You are responsible for 20 SQL Server 2005 computers. These computers are monitored by other administrators who are required to ensure that query response times meet company service level agreements (SLAs). You need to provide these administrators with a consistent way of monitoring query response times on the servers. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create SQL Server Profiler templates that include query start times and end times.
Distribute these templates to the database administrators.

B.
Write a query that queries the sys.dm_db_partition_stats dynamic management view (DMV). Distribute this query to the administrators.

C.
Create an XML document that contains the event and column names of the query response times that must be captured in SQL Server Profiler. Distribute the XML file to the database administrators.

D.
Instruct the administrators to use System Monitor to monitor cache hit ratio statistics.

Explanation:
You can use SQL Server Profiler to create templates that define the event classes and data columns to include in traces. After you define and save the template, you can run a trace that records the data for each event class you selected.
you can use template on many traces,the template is not itself executed.


Leave a Reply