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 ...

Get Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.