• First thing to do is check out the wait stats. Paul Randal has a great query you can use to gather this information - see link below. The article will provide you with a lot of information as well.

    http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/[/url]