• I'd say you probably need more memory. The page swapping is drive up your CPU load. Check drive IO while you're looking, it's probably high as well. All things considered, more memory never hurts and is easier to add than drive space.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/