Preview Mode Links will not work in preview mode

Voice of the DBA


Welcome to the Voice of the DBA, thoughts from Steve Jones on databases, SQL Server, and life.

Jan 28, 2019

Monitoring a database server is something that many of us know is important, but we often take the process for granted. Whether we've purchased a tool, like SQL Monitor, or we've built our own system, we often set up a watcher for our systems and rarely view the details unless something goes wrong. I'm not sure that's the wrong approach as part of the reason monitoring is set up is to allow data capture in the background and remove one more task from our daily workload.

Monitoring isn't necessarily simple, however, and while I still debate the best way to do this in many organizations, I realize that monitoring isn't necessarily something I want to build in house. There is enough work to just work with the data that other systems might output that I really want some other software in place that is built to perform monitoring for specific technologies. In reading about the complexity for the Stack Overflow monitoring systems, I realize that this can become very complex for a "set it up and let it run in the background" configuration.

Read the rest of The Devil is in the Monitoring Details