Chapter 18. Monitoring and analyzing performance
This is one of the most important chapters in this book. Aside from index maintenance and monitoring, performance monitoring is one of the most impactful things you can do as a SQL Server administrator. In this chapter, I’ll focus on some of the easiest ways to monitor SQL Server performance, particularly from the perspective of SQL Server 2012 and later.
This chapter is, I’ll admit, a wee bit on the long side. You may need a couple of days’ lunches to go through everything.
18.1. Key Performance Monitor counters
Windows’ built-in Performance Monitor tool remains one of the best ways to get a quick look at performance, and for compiling long-term performance information. It isn’t an enterprise ...
Get Learn SQL Server Administration in a Month of Lunches 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.
