• As a first try, look at that instance, "Reports", "Standard Reports", "Total CPU Time" and "Average CPU Time".

    On rebooting, it depends. If you have a lot of non-SQL stuff running on the box, reboots can help, since RAM may get fragmented or lost (memory leak). Also, SQL itself at times must allocate contiguous RAM, and too much RAM fragmentation interferes with/can delay that.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.