You are an awesome DBA. You have complete control over your dominion. You have all your backups automated and the testing of those backups is automated. You have alerts properly configured on all your servers. You have your index maintenance plans running regularly. You ride a unicorn to the office and George Hamilton asks you […]
For the final part of this series on Uptime Monitoring, I’d like to go over my testing methodology. The reporting process is somewhat complicated, so I want to be confident the figures my procedure outputs are correct. Here again, is the sample data I am working with: LogDate UptimeMinutes 2013-08-21 12:00:00 100 2013-08-21 14:15:00 115 […]
This is the final almost final part of my series of articles about creating a process to monitor your SQL Server for downtime. Part 1 can be found here. Part 2 can be found here. Reporting Now that we’ve got a process in place to gather data, we need to create a way to report […]
Last time, I talked about the issues with trying to get a server to monitor itself for downtime. In part 2 of this series, I’ll talk about my solution for monitoring. In the final part, I’ll discuss how to use the logged data for reporting. Part 1 can be found here. Part 3 can be […]
This is part 1 of a three part series on using home-grown up time monitoring for your SQL Servers. Part 2 can be found here. Part 3 can be found here. I was recently asked by my company’s management to provide some key performance indicators (KPIs) for our critical SQL Servers. One of the KPIs […]