You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2005
instance that host a database named Products. You want to monitor query response times on the
Products database.
How would you accomplish this task?
A.
You should make use of the SQL performance monitor.
B.
You should make use of SQL Server Profiler templates with start and end times of the queries.
C.
You should make use of startup parameters with trace flags and restarting the SQL instance.
D.
You should capture the SQL:BatchCompleted event classes in Windows System Monitor.
Explanation: