CHAPTER 8
Monitoring and Reporting
Proactive, continuous monitoring and alerting are essential to managing multiple SQL Server instances. By setting up automated monitoring, you ensure that you are being proactive and not reactive to a potential technical issue or outage before escalation. With targeted monitoring, you can get in front of and resolve a situation before it becomes known to the general user population and management. There are a number of out-of-the-box solutions, as well as established third-party vendors. I will talk about and recommend some in this chapter.
In Chapter 2, I discussed what data to collect, such CPU, memory, I/O, ...
Get Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance 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.
