SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Summary

In this chapter, you learned about the different performance tools that are available in SQL Server 2008 and Windows Server systems. You began by reviewing important performance tuning principles and then you explored the concurrency mechanisms of SQL Server. Next, you looked at the SQL Server Profiler and learned to create trace files with this powerful tool. Then the Database Engine Tuning Advisor was explained and demonstrated. With this tool, you can get recommendations to help improve the performance of your existing databases. You moved on from there to the System Monitor in its many implementations in the different Windows Server systems. Finally, you explored some new tools in SQL Server 2008, including the Resource Governor and ...