How to test if a SQL Server 2008 database can serve 200 concurent users

Question

I have a SQL Server 2008 database in 3NF.

I must check if the db can support many concurent users.

Which is the best method ?

Is there any free tool to do this ?

Thank you very much.

score 1 · Answer 1 · answered May 21 '10 at 21:37

1

The database design and the queries you run against it are vital; no generic answer can be reliable.

I recommend you start with the MS SQL community's benchmark tools.

answered May 21 '10 at 21:37

Richard T

4,570
5
37
49

Thanks. Yes, the design and queries are vital. What do you think about this tool ? http://www.seapine.com/qawizard.html – sh00 May 21 '10 at 21:40
Sorry, don't know that one. -shrug- – Richard T May 22 '10 at 16:01

score 1 · Accepted Answer · answered May 21 '10 at 21:41

1

SQLQueryStress - http://www.datamanipulation.net/SQLQueryStress/documentation/documentation.asp

and

SQLStress - http://www.sqlstress.com/Overview.aspx

Both look like a good fit for what you want to do.

answered May 21 '10 at 21:41

Sijin

4,530
21
22

Thanks ! Yes, I am looking for this kind of tools. – sh00 May 21 '10 at 21:44

score 0 · Answer 3 · answered May 21 '10 at 21:27

0

Since uses are hopefully not accessing the database directly you must have some front end, that is where I would perform my load test. You can use TFS to do load tests as well as Selenium.

answered May 21 '10 at 21:27

Dustin Laine

37,935
10
86
125

score 0 · Answer 4 · answered May 21 '10 at 21:37

Assuming that you have created some kind of web front end that queries your database, then the excellent open source tool Sahi would really help you out. The test toolkit allows you to simulate multiple users using your website - and therefore your database.

How to test if a SQL Server 2008 database can serve 200 concurent users

4 Answers4