• When you have a situation like this, there are a lot of places that have tools that will automatically run through all the diagnostic information for you.

    One of my favorite places is http://www.brentozar.com/first-aid/downloads/. sp_AskBrent is a good place to start.