SQL Server Profiler   «Prev  Next»

Using SQL Server Profiler - Exercise Result

You entered:

Using SQL Server Profiler Results

SQL Server Trace Example
SQL Server Trace Example

Determining amount of time for SQL to execute

  1. What SQL user takes the longest time for a single query and what is the length of time?
    The user is dfp and the duration is 115.
  2. What is the most amount of cpu that a command took and who did it?
    The user is sa and the CPU usage is 1235.
  3. What SQL user takes the most I/O for a query and how much I/O did that user take?
    The user is Paula and the total I/O is 2030 reads + 321 writes for 2351 I/Os.