O'Reilly logo

Microsoft by Hilary Cotter, Ross Mistry

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19 Performance Tuning and Troubleshooting SQL Server 2008

Speak with any DBA and the conversation will eventually turn to performance issues and troubleshooting. This is because a large part of a DBA’s time is spent on performance tuning and resolving issues that can ultimately affect a SQL Server system, database, or application. It is also worth mentioning that performance tuning and troubleshooting are such popular subjects simply because they are entwined with so many other tools and processes—making it one very large topic. Specifically, performance tuning and troubleshooting performance issues are iterative processes that include monitoring, troubleshooting, and adjusting. When troubleshooting SQL Server performance issues, it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required