Most database load tests I have seen run one or two queries in a loop. That tells you how fast those queries are when nothing else is happening. It does not tell you what your database does on a normal Tuesday, when one lookup is called 120,000 times an hour, a customer listing 45,000 times and a report 400 times, all competing for the same buffer cache, the same connections and the same locks. The good news: your database already knows that profile. This post shows how to export it and turn ...