Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How many requests can SQL Server handle per second

Author  Topic 

zengqingyi12
Starting Member

1 Post

Posted - 2009-12-01 : 03:29:57
I am using JMeter to test our application 's performance. but I found when I send 20 requests from JMeter, with this the reason result should be add 20 new records into the sql server, but I just find 5 new records, which means that SQL server discard the other requests(because I took a log, and make sure that the insert new records are sent out to sql server.)

Do anyone have ideas ? What's the threshold number of request can SQL server handle per second ? Or do i need to do some configuration ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-12-01 : 16:01:43
How are you adding the records?
Did you use an IDENTITY on the target table?
Did you manage your own primary key?



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-01 : 16:09:49
On one of our high-end servers, we see that SQL Server is able to process 3000-4000 queries per second. On our lower-end servers, it's at about 500 queries per second.

SQL Server is not discarding your other requests. Run SQL Profiler to determine what is happening.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -