How Do You Stress Load Dev Database (server) Locally?

Wow, this title gave me immediately 'The question you're asking appears subjective and is likely to be closed.' Anyway, after some searching and reading, I decided to ask it. Com

Solution 1:

As one word of warning: It is easy to stress test alocal db to see whether the db design is good / bad / missing (bad indices etc.)

Trying to get real time perforamnce metrics out of that is futile - even with plenty of memory (unlikely - most workstations are crappy memory wise compared to real db servers) your disc subsystem will SUCK (in 100 meter high letters) comapred to what a real db server can throw at it. Becasue normal dev local databases only have one or maybe two discs, while db servers often utilize a LOT more and a LOT faster discs. As such, waht may be SLOOOOW on your workstation may be a seconds operation on the sever.

But again, thigns like bad index usage is visible.

Solution 2:

You are correct.

There are no general purpose stress loading testing SQL tools independent of RDBMS.

And how could there be? You can throughput benchmark the hardware sub-systems in isolation (such as SAN, network), but the performance of your database depends very much on your access patterns of your application(s), the type of RDBMS, the hardware.

Your best bet is to load test your application connected to your database on a representative hardware platform. There are several tools that can do, including the Ultimate version of Microsoft Visual Studio 2010.