Re: transactions per seconds - how many?

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.


"Rogas69" <rogas69@xxxxxxxxxxxxxxxx> wrote in message
news:OyeI$bdZFHA.3364@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>


.

Relevant Pages

  • RE: Timeout Expired for no apparent reason
    ... How do I set the timeout for transactions? ... "Steve S" wrote: ... >> for each row updates a row in another table and then updates the original ...
    (microsoft.public.data.oledb)
  • Re: computational model of transactions
    ... How do "other intervening transactions" exist ... attribute; whereas replacement doesn't. ... Assuming that the above updates occur in different transactions, ...
    (comp.databases.theory)
  • Re: buffering & transactions
    ... > an extended process involving calculations and several updates to various ... (Just what transactions were made for, ... documented at MS) ways to get invalid data. ...
    (microsoft.public.fox.programmer.exchange)
  • Container-managed Transactions scope
    ... Updates and Deletes are inside an EJB method. ... the Container-managed Transactions be extended to the DAOs automatically. ... If container do keep track of transactions like that then how many nested ...
    (comp.lang.java.programmer)
  • Re: Container-managed Transactions scope
    ... Updates and Deletes are inside an EJB method. ... > the Container-managed Transactions be extended to the DAOs automatically. ... > If container do keep track of transactions like that then how many nested ...
    (comp.lang.java.programmer)