Wednesday, March 7, 2012

How to Stress Test SQL Server

I am interested in finding out how our SQL Server is going to do when most
of the people in the facility are getting on there. Are there any resources
for stress testing the server? I am using a ASP developed intranet, and
would like to know if the server is going to bomb when I get 10 - 15 people
working on the data.
Thanks,
DrewDrew,
As you're developing in a web environment, you could possibly use the Web
Application Stress Tool, which you can get here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062a-439e-a67d-75a89aa36495&DisplayLang=en
"Drew" <dlaing@.NOswvtc.state.va.SPAMus> wrote in message
news:u3hfbMSiEHA.3264@.tk2msftngp13.phx.gbl...
> I am interested in finding out how our SQL Server is going to do when most
> of the people in the facility are getting on there. Are there any
resources
> for stress testing the server? I am using a ASP developed intranet, and
> would like to know if the server is going to bomb when I get 10 - 15
people
> working on the data.
> Thanks,
> Drew
>|||Also, for disk I/O related:
http://support.microsoft.com/?id=231619
--
Anith

No comments:

Post a Comment