We live in a world where everything must be available 7 days a week, 24 hours a day, 365 days a year. Yet we all know what happens if we never stop to change the oil in our car. One day the engine will cease up. No matter how busy you are you need to find the time to do maintenance in your database or you are putting your business at risk – because the database will crash – at the worst possible time!
Are you crazy busy?
Has it been 6 months since the last database patch? Keeping up with all the patches is never easy but it is a necessary evil. Patches fix known security holes and many other issues. Not keeping up with patching means that one day someone might breach your database – a problem that could have been avoided by keeping current with the latest database patches.
Are you running an unsupported version of the database? This is an accident waiting to happen. It is better to run a supported version of SQL Server in mode 80, where it mimics the older version, than it is to keep running the older version. At least then if you have an issue the vendor will need to support you.
We see a lot of DBAs who keep waking up in the middle of the night to fix the backup that keeps running out of space. Are you so busy that you don’t have time to make sure all the databases are being backed up? How many times as a SQL Server DBA did you add a database but never found the time to add it to the backup routine? Without a point-in-time-recovery backup scheme in place you will lose an entire day of work if you ever have to use the backup. Just like changing the batteries in your smoke detectors every year in your home, it is important for you to fire drill your backups at least once a year.
We all know what it means when your database corrupts and you have no backup – you are constantly dealing with performance problems. Today’s databases will self-tune, but they’ll only self-tune if the proper database maintenance jobs are in place and running every day.
If any of the things we’ve just talked about sound like your organization then you are on the verge of not only being crazy busy but just plain crazy!
Every one of these items could have severe consequences for your business Putting proper database maintenance plans in place will prevent many of the performance problems in the first place yet you are too crazy busy to get it done.
To get past crazy busy consider Database Administration as a Service from a company like Ntirety. A typical client saves over 40%. And gets access to an expert team of DBAs, 7×24 coverage, and best of breed tools and reporting. In today’s world where we are under constant pressure to do more with less, Database Administration as a Service represents a cost effective way to get your DBA staff the extra help they need at a price point your organization can afford.