Load Testing Crash Course
Here is an excellent post from Kendra Little regarding this. 

http://www.brentozar.com/archive/2012/06/load-test-sqlserver/

There are several tools out there, both commercial and free. In past when I had need I used
Adam Machanic's SQLQueryStress

SQL Load Generator on CodePlex is another free tool you can use also.