Monitoring performance and resolving performance issues should be described in their own book but all information is useful.
In the beginning, several approaches used in performance monitoring were described, namely, the top-to-bottom approach and proactive monitoring.
A lot of information was covered in the Tools for monitoring performance section. As seen, Microsoft provides a wide set of tools and techniques to monitor and troubleshoot SQL Server. Most of them are graphical, but it's also recommended to have brief knowledge of non-visual objects like dynamic management views and functions.
The Indexing and maintenance section demystified typical index types, their usage by SQL Server in common situations, and also some guidance to indexing was covered.
In the next chapter, we will show what to do when things go wrong. We will use some similar techniques to detect...
