Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Why do DBAs like to say “It Depends” so much?

Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice that “it depends” is almost always followed by a series of questions. This is very similar to the Chaos theory that as I understand it basically says that if you knew everything you could predict anything.

Simple example. “Why is the query plan for my query changing between one day and the next?” The number of possibilities here are staggering. Your data could be changing, your statistics could have been updated, your query could have been compiled with different parameters than last time. Heck, you could have added more memory to the server. You can see how no one could possibly give a good answer without asking a lot of questions.

On top of that DBAs are trained (generally by themselves unless they are very lucky) to try to help find and fix the problem, which is not necessarily the answer to the question. “How do I stop my instance from using up all of the memory on my server?” This at face value is fairly simple. Change your max memory settings .. or add more memory. But WHY are you using up so much memory? The answer may be that you just need more memory for your workload. On the other hand you may be using it inefficiently and a couple of indexes could dramatically reduce the amount of memory that SQL needs.

So next time you hear “It depends” don’t think “The DBA is being flip again.” Think “What else can I tell the DBA so they can give me a well thought out, intelligent answer.” Now DBAs being DBAs he/she may very well be trying to obnoxious.. but probably not.


Filed under: SQLServerPedia Syndication Tagged: it depends

Comments

Leave a comment on the original post [sqlstudies.com, opens in a new window]

Loading comments...