Can someone point me at a good resource to get a crash course in load testing. I have a sql server machine that I need to load test but I havent been thruogh the process before. Also we do not have any third party software for this or money to purchase any so that option would be out.
Here is an excellent post from Kendra Little regarding this.
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.