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 ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
