transactions per seconds - how many?

  • Thread starter Thread starter Rogas69
  • Start date Start date
R

Rogas69

Hi all,

I would like to ask you, how many transactions per second can you achieve on
your sql servers? I have simple stored procedure that updates records in
small table - and I cannot go over 220 trans per sec using ado .net... Is it
ok?
I am using generated dataadapter (framework 2.0, beta2). The procedure
returns string (ExecuteScalar).
The sql server runs double xeon machine and 2 scsi drives. Database files
are split between drives. Memory and processors aren't the bottle neck,
average disk queue is not as well. Page splits are minimal.

Peter
 
Peter,

For a sproc that does updates, 220 transactions per second is about the best
you are going to get out of SQL-Server. Use a custom updateCommand on the
adapter and batch the updates per transaction to increase performance.

If you want real-time performance you'll need to look at other database
vendors like Polyhedra (http://www.polyhedra.com) which can process several
thousand transactions per second.

Ad.
 
It really depends on the test and who's running it. Each vendor has their
own opinion about who is "best". IMHO, it depends on what you're trying to
do. Many of the standard TPC benchmarks exceed 500,000 transactions/second
but these are on monster machines costing millions.

http://redmondmag.com/news/article.asp?EditorialsID=5816

If, however, you're looking for performance improvements, you might consider
changing your design to handle the bulk operations more wisely. See my posts
here and elsewhere on using BCP to increase UPDATE performance. With an
ordinary machine I can "update" over 400,000 rows in under 30
seconds--that's over 13,000 rows/sec using BCP.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Thanks Bill, I am already considering change of my design towards bulk
operations.

Peter
 
Back
Top