Can we create load on SQL Server database through OpenSTA?

Hello Friends,

Recently I am assigned a project where I need to do performance testing on an ASP.Net 3.5 Web Application which is running MS SQL Server database as a back-end.

Following are my questions regarding this:

1). If I am recording a script that is for creating a scenario for 100 users signing up on our web site and run that through commander with 100 users then will system going to create those 100 users actually in the database?

2). If I run the test with that user load then I am able to see from IIS Worker Processes that simultaneous requests are being made to the web server but is there any assurity that same load is also being made onto the database server?

Please reply to this as soon as possible.

Thanks in advance.