by Kevin S
Now that we are creating databases, I thought that I would share an article that I found in where a DBA describes a day in his work and some tips on supporting the daily tasks. The article, named “The Case of the Missing Index”, starts off by going through almost humorously through his day as his co-workers ask him to fix an issue with the DB application. He runs through his routine of troubleshooting and eventually finds the culprit which, as you may of guessed, was a missing index file which had been deleted by a co-worker in order to create more room on the hard drive.
Here are 5 tips he gives at the end of the article:
Create highly compressed backups and schedule regular restores including full verification of your backups.
Monitor your servers in real time and be automatically alerted to problems before users notice them.
Proactively monitor data growth and make the most of your storage space.
Get access to your backup data without requiring the space for a full restore. Simply mount your backup as a fully functional, live database requiring near-zero additional storage space.
Protect your data from unauthorized access with 256-bit AES encryption.
I found this article because I had to do some trouble shooting myself this weekend to get my database up and running. While this article did not in fact help me fix my problem, I did find it cool to see that it gave insight to how someone does go about to assess and fix a problem in the real world. He stressed the importance of using the right tools for the job and to not jump to conclusions until all the facts are sought out.
I think this is a great article, even though it’s written to sell some software (which he reffers to as the SQL DBA Bundle). I’m sure there’s plenty of software in the market which do all of these things and a lot of it may already be built into what we already have.
Fritchey, G. (2012). The case of the missing index. Retrieved from http://www.red-gate.com/products/dba/dba-bundle/entrypage/hard-earned-lessons?utm_source=sqlmag&utm_medium=roadblock&utm_term=9989&utm_content=hard_earned_m1&utm_campaign=sqldbabundle