In this chapter, we saw some basic performance tuning tips and SQL Server internals, which are essential to the understanding of troubleshooting. The SQL Server consists of several different layers, where it has it's own operating system inside, which is responsible for many tasks and is a subject for several DMVs, which we saw for troubleshooting. We can then check many of the performance counters, which closely relate to the storage and query processor layers to see how SQL Server is working and if there is any pressure on any of the subsystems such as CPU, memory, disk, or network.
Going further with the SQL Server analysis, we introduced the Wait Statistics troubleshooting methodology and possible DMVs to use to get more insight on the problems occurring in the SQL Server. At the end of the chapter, we extended the information about several wait types, which were...
