Which of the following is benefit of SQL Server Profiler ?
A. Capturing the series of Transact-SQL statements that lead to a problem.
B. Finding and diagnosing slow-running queries
C. Correlating performance counters to diagnose problems.
D. All of the mentioned
Answer:A
Which of the following is benefit of SQL Server Profiler ?
A. Capturing the series of Transact-SQL statements that lead to a problem. B. Finding and diagnosing slow-running queries C. Correlating performance counters to diagnose problems. D. All of the mentioned
Explanation:Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. 2. Point out the correct statement :