We see a lot of SQL Servers.
During our sales process, prospective customers run sp_Blitz on their SQL Server, and we talk through the results. I see a lot of horrifying stuff.
Over time, I’ve built up a pretty good sense of signs that a SQL Server is running around loose in the data center, juggling chainsaws, drinking Keystone Beer, not wearing any pants.
5. Some of the databases haven’t been backed up. sp_Blitz alerts you if there’s no backups in the last two weeks, which is bad. You would probably think if that’s the case, none of the databases have been backed up – but that’s almost never true. What usually happens is that someone set up backups once, picked the specific databases they wanted backed up, and then never looked at that list again. They added more databases, but they didn’t configure backups to match.
4. CPU schedulers and memory offline. There are two install ISOs for SQL Server Enterprise Edition with very confusing names (one just says Enterprise Edition, and the other one says Core-Based.) One of them only supports 20 physical cores. Way too often, I see SQL Servers where 1/4-1/2 of the CPU cores and memory simply aren’t even turned on.
2. No CHECKDB, ever. sp_Blitz reports on the last time DBCC CHECKDB finished successfully. I’m constantly amazed that people have never even tried to run CHECKDB on any of their databases, period. At the same time, when I ask how much data they want to lose, the answer is, “None.”
1. Databases in full recovery with no transaction log backups. A popular myth (and I used to believe it too, once!) is that full backups clear out the transaction log. Folks put a database in full recovery model, do full backups, and think they’re fine because those two “full” terms match up. Meanwhile, their database is 50GB, and their log file has grown to 500GB.
When I see this stuff, I buckle the belt on my office chair, get ready for a bumpy ride, and ask the client not to turn on their webcam (or at least not point it down.)
Do us both a favor. Run sp_Blitz on your servers today, and put some pants on them.