• I think you should find out what the slowness truly is. Search web for SQL Server 2005 Waits and Queues, a marvelous best practices white paper from Microsoft. in it you will find track_waitstats_2005 and get_waitstats_2005. Learn how to use an interpret the output from that. Also check out file IO stalls using sys.dm_io_virtual_file_stats.

    Best, if you really want to get things running faster quickly, is to hire a performance analysis/tuning professional for a quick engagement. You can flop-and-twitch for days on this forum and not get things running right when a good consultant would likely have you fixed up in a matter of minutes to hours. He/she could also teach you how to monitor effectively in the future.

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