Chapter Essentials
Performance Tuning Principles Performance tuning is not as simple as throwing more hardware at a performance problem. You must use systems thinking and avoid the common performance tuning myths.
Performance and Troubleshooting Tools If you're going to do much performance analysis and enhancement, you'll have to understand the available tools. Windows provides several tools, including the Task Manager, System Monitor, and Event Viewer log files. SQL Server 2008 also provides tools including the Activity Monitor, SQL Server Profiler, Database Engine Tuning Advisor, and DBCC.
Blocks, Locks, and Deadlocks Locks are normal in a multiuser database system and will result in blocking. Blocking occurs when one connection has a resource ...
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.
