In the past 5 months I have started two different jobs, so that leaves it up in the air as to which job or jobs (plus a previous job did some of these) are practicing these bad habits but these are the top 10 things that drive DBAs crazy when they start new jobs. Keep in mind the company had never had never had a DBA before but still come on there are too many free resources out there for accidental DBAs and they had written plenty of stored procedures.
- Everyone can guess this one. Go ahead try before you read it. Everyone is a you guessed it a sysadmin. There is just way to many things that can go wrong from drop databases to settings being changed to inconsistent things being setup that the DBA doesn’t know about after they have fixed up the server.
- Production databases having a SLA but no recovery strategy, i.e. databases in SIMPLE mode so no log backups, but then test databases in FULL mode. Just why?
- Having test databases on the same server as your production databases. Why when you have the resources to create test servers.
- Running a server without enough memory, seriously a 300 GB database (not to mention the other databases on the server competing for that buffer pool) trying to run in under 64 GBs is usually going to be slow and you have the resources to give it max standard edition will take at 128 GBs and you have it configured to use a minimum of 80 GBs anyways.
- Having compatibility modes set all the way back to SQL Server 2008, hey we are running 2016. Let’s use the new cardinality estimator.
- All the database files on one drive, let alone on the C drive where snapshot backups are taken quite frequently freezing IO.
- Oh, and can we have SQL Agent Alerts please, how did you know there was something wrong with the server before?
- Having databases with 10,000+ DTA indexes yes you read that number correctly, I saved over 400 GBs removing the include columns from them. And oh got rid of the DTA statistics.
- Still not have your Power Plan set to High Performance.
- Lastly not having complete maintenance plans, like only having backups or not backups or only backups and nothing else, or even setting up everything including Shrink Database. Please don’t use those go use Ola’s scripts.
- Bonus one no patches having ever been installed on the operating system or SQL Server in years.
Any company without a DBA or any new DBA look at Brent Ozar’s 6-month Training Plan , it’s free.
If you had any things that have driven you crazy when starting a new job leave them in the comments, I’m curious I may need to check them out.