Review

3 4

Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."

1. You have recently been hired as the new database administrator for a medium-sized database. You have been tasked with improving the performance of the database, although no specific problems are apparent. Where should you start?
2. You want to be able to quickly view overall levels of resource use on a computer running SQL Server to determine whether resources are adequate. What is the most appropriate tool for the task?
3. You have been viewing current server activity through SQL Server Enterprise Manager. You have noticed a number of blocking locks. What steps should you take to determine whether this is a serious problem?

Answers