Review

[Previous] [Next]

The following questions are intended to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A, "Questions and Answers."

1. Users complain that the server slows down considerably every day at 2 p.m. How can you find out what is causing this delay?

Answer

2. You want to find out the locks that are being held on a specific SQL Server table. What tools would you use?

Answer

3. You want to see a query plan and the statistics for a specific query in SQL Server Query Analyzer. What steps must you take?

Answer