• Rebuild all your indexes... That should create some memory pressure/data cache. :w00t:

    Seriously though this can do well, but beware if you have high transaction volumes and are not using Enterprise edition.

    With Standard edition rebuilding a the Clustered Index for a table can cause blocking during the rebuild.