• Do you have performance problems on the server? Given that you are using only 1% of CPU, I would be surprised if you did. And if you DO, it almost certainly isn't because of CPU problems. I would look for locking and IO stalls as a more likely cause. waits aren't just about percentages - how many and most importantly how LONG are they taking per unit time is what counts.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service