Blitz Result: Non-Default sp_Configure Setting

“I wonder what this button does…”

This part of our SQL Server sp_Blitz script checks sys.configurations looking for settings that have been changed away from their default values.

This doesn’t necessarily indicate a problem, but to explain it, we like to talk about modern airplanes.  They’re so advanced that they practically fly themselves.  In fact, airplane cockpits have two things: a pilot and a dog.  It’s the pilot’s job to feed the dog, and it’s the dog’s job to bite the pilot if he touches anything.

Unfortunately, SQL Server doesn’t come with a dog, so people end up poking around in all kinds of settings that they probably shouldn’t change.  When in doubt, back it out.

To Fix the Problem

These settings may not be a problem, but you’ll want to know that they’re in place, and start asking questions about why they were changed.

Return to sp_Blitz or Ask Us Questions