CHAPTER 27
System Troubleshooting
Things do not always work as expected. System performance can degrade over time when the amount of data and load increases, or sometimes a server can become unresponsive and stop accepting any connections at all. In either case, you need to find and fix such problems quickly while working under pressure and stress.
In this chapter, we will talk about the SQL Server execution model and discuss system troubleshooting based on Wait Statistics Analysis. I will show you how to detect common issues frequently encountered in systems.
Looking at the Big Picture
Even though this chapter focuses on the troubleshooting ...
Get Pro SQL Server Internals 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.
