In my case the 3 million rows was full population of the database for six months worth of usage.

I had specifc fixed limits in the system I was testing and actual data would be at most 2 million rows, given the nature of the application. So doing all the load testing with 4 - 6 times the allowed data volumes was a good test.

hey thats the beauty of redgate sql data generator though. 😉