When you run SP2 against your PC, after a couple of screens, the list of things to upgrade comes up with checked or unchecked boxes. If you don't have that...
We have a couple of options where I work to give the developers access to production or near production data. First, we have a review login set up on production....
I would try the maxdop option (maximum degree of parallelism) on your select query and see if that helps. That limits the query to use a specific number of processors....
Cache hits may not increase just because you increased the amount of memory. Most of the issues with lower cache hits that I've seen are a result of other problems...