We do the trace-replay method of testing. However, you lose the original concurrency aspect. I think it would also be worthwhile to run some kind of load-test with...

We have been running on SQL2008 Standard edition (not R2) and recently upgraded our hardware to a relatively massive machine with two 12 core processors and 256GB of memory. ...

I think the ideal situation is to set up automated monitoring to do most of that for you. Let the machines do the work as much as possible...

You could make a custom Fathead at fathead.com. They have a variety of size options and print on a vinyl material with a low-tack adhesive that allows you to...