Load test database (sql server)

[martin]

Hi,

does anybody know of any tools (preferably free) that i could use to test my
asp code accessing an sql server database under load.

what i mean is, if I have a page that accesses a database, i would like to
stimulate 100,200,300 ect connections to that page at the same time.

The point of this is to see if there are going to be any locking/blocking
issues with the db and asp code.

I would also like to test MSDE in a similar environment (yeah, iknow it has
a five connection limt, but i'm not sure how connection pooling and the
length of time connections are open for will affect this.)

I have heard there is a tool to do this in vs.net but i have yet to come
across it.

any help is appreciated.

cheers

martin.

[Cowboy \(Gregory A. Beamer\)]

[url]http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itsolutio[/url]
ns/intranet/downloads/webstres.asp

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

************************************************** **************************
****
Think outside the box!
************************************************** **************************
****
"martin" <martindevroom@hotmail.com> wrote in message
news:u0MUVgpSDHA.2276@TK2MSFTNGP10.phx.gbl...

> Hi,
>
> does anybody know of any tools (preferably free) that i could use to test

my

> asp code accessing an sql server database under load.
>
> what i mean is, if I have a page that accesses a database, i would like to
> stimulate 100,200,300 ect connections to that page at the same time.
>
> The point of this is to see if there are going to be any locking/blocking
> issues with the db and asp code.
>
> I would also like to test MSDE in a similar environment (yeah, iknow it

has

> a five connection limt, but i'm not sure how connection pooling and the
> length of time connections are open for will affect this.)
>
> I have heard there is a tool to do this in vs.net but i have yet to come
> across it.
>
> any help is appreciated.
>
> cheers
>
> martin.
>
>