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® SQL Server 2008 Management and Administration 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.
