Summary


In this chapter, you looked at how to optimize the performance of queries in SQL Server 2005. You started by looking at the different categories for poor query performance and learned how you can use the Database Engine Tuning Advisor to quickly tune your SQL Server 2005 database solution.

We then covered different techniques that you can use to help you identify potentially poorly performing queries.

Next we discussed what execution plans are and how to generate and analyze them. We provided some tips on what to watch out for in execution plans and general tips for optimizing the performance of poorly performing queries.

We then covered the importance of maintaining and optimizing indexes for query performance. You looked at what index fragmentation was and the difference between reorganizing them and rebuilding them.

Locking and concurrency are other important topics, and you examined how the lock manager works in SQL Server 2005. Transaction isolation levels defined the way transactions operate in SQL Server 2005. Again, we covered ways in which you can override the default behavior of SQL Server 2005.

Finally, we finished up with an examination of what deadlocks are in SQL Server 2005, how to detect them, and recommendations for minimizing them.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net