SQL Server Profiler   «Prev  Next»

Trace Events in SQL-Server - Exercise

SQL-Server Trace Events

Objective: Match the performance issue with the correct event class to track.
In the left column below are seven performance issues and, in the right column, corresponding events that you can trace to help address the issues. Click an issue once in the left column, then click an event once in the right column to make a match. When you think you have all of the issues and events matched correctly, click the Submit button and you will see whether or not you've matched the terms correctly--green lines mean the match is correct, red lines mean the match is incorrect. If you didn't get the matches right the first time, click Clear to erase your matches and try again. When you have completed the exercise, click the Submit button to see the correct answers.

Exercise Scoring

You will receive 3 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.
  1. The system’s performance is low and you are using a higher-than-average number of cursors
  2. There are a number of hanging processes
  3. You notice that the application is behaving slowly
  4. You need to check to see if parallel queries are successful
  5. You are having locking problems
  6. You want to know how long it takes to read every row in a table
  7. You want to check the query execution plan
  1. Database Objects
  2. Scans
  3. Sessions
  4. Cursors
  5. Miscellaneous
  6. SQL Operators
  7. Locks