Non-Default sp_Configure Setting
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.