Summary
Monitoring performance and resolving performance issues could take up a book on their own, but any information is useful information.
First, we described several approaches that are typically used in performance monitoring; that is, the top-down approach and proactive monitoring.
A lot of information was covered in the Tools for monitoring performance section. Microsoft provides a wide set of tools and techniques we can use to monitor and troubleshoot SQL Server. Most of them are graphical, but it is also recommended to have a brief knowledge of non-visual objects such as DMV and functions.
The Indexing and maintenance section demystified typical index types, their usage by SQL Server in common situations, and provided some guidance regarding indexing.
In the last part of this chapter, we look at some real-life use cases for performance troubleshooting on SQL Server.
In the next chapter, we will show you what to do when things go wrong. We...
