Review

3 4

The following questions are intended to reinforce key information presented in this 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. Name a monitoring feature that sends database information to a Network Management System (NMS).
2. Name a SQL Server tool you can use to monitor current SQL Server activity.
3. Several users inform you that database performance levels seem to change right around the time that staff rotations occur. How can you use SQL Profiler to determine if the staff rotation has anything to do with changing performance levels?
4. You are concerned about database security. How can you use the SQL Profiler to alleviate your concerns?
5. How can you reduce the amount of data collected by a trace?
6. Where can trace data be stored?
7. As you move through the Index Tuning wizard screens, you see that choosing a script from the Query Analyzer is not an option. What is the most likely reason for this result?
8. How can you start a trace in Query Analyzer?
9. What application requirement must be met for the application to benefit from a federation of servers?
10. How must member tables be configured to support distributed partitioned views?
11. What are two ways that CPU consumption can be reduced when performing an analysis with the Index Tuning wizard?
12. The Index Tuning wizard can create indexed views on what SQL Server editions?