Load testing a SQL database server

I have a web-based application that interacts with a SQL database. Just as an example, a user will go into the application and pay a bill. This will create a record in the database showing that the bi...