m82labs   about   posts   categories   talks   feed

Handling SQL Agent Job Failures

by Mark Wilkinson · August 30, 2017

Hopefully you don’t experience a lot of job failures. But when multiple high-frequency jobs start failing, your inbox can get overloaded. Besides being annoying, an inbox full of job failure emails can make it hard to sift out the signal from the noise. In this post we’ll walk through a system that I have used to monitor job failures on 100’s of instances running 150+ jobs a piece, many of which run every 5 minutes.

Read More...

Managing the SQL Server Error Log

by Mark Wilkinson · July 13, 2017

We typically think of error logs as somewhere to go to find issues, but what if your error logs ARE the issue? Like most anything else in SQL Server, if you neglect your error logs you can run into trouble. Even on a low-traffic SQL Server instance, a bad piece of code, or a hardware issue, could easily fill your error logs, and with the introduction of Hekaton in SQL Server 2014, the SQL Server error log started getting a lot more data pumped into it than you might have been used to before. What this means for the DBA is that you can quickly start filling your main system drive (if your SQL install and error logs are in the default location) with massive error logs. So what questions should you be answering about error logs to make sure you don’t run into problems?

Read More...