transactions per seconds - how many?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Rogas69" <rogas69@xxxxxxxxxxxxxxxx>
Date: Tue, 31 May 2005 12:52:39 +0100

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

.

Follow-Ups:
- Re: transactions per seconds - how many?
  - From: Adrian Moore

Prev by Date: Re: simple sql question
Next by Date: Re: Best way to get started?
Previous by thread: Re: simple sql question
Next by thread: Re: transactions per seconds - how many?
Index(es):
- Date
- Thread

Relevant Pages

Re: transactions per seconds - how many?
... here and elsewhere on using BCP to increase UPDATE performance. ... > on your sql servers? ... > The sql server runs double xeon machine and 2 scsi drives. ...
(microsoft.public.dotnet.framework.adonet)
Check validity of NT username
... Is there a stored procedure that can be run where you pass in a NT username ... have users setup with access to our SQL Servers and as somebody leaves the ... company we want to remove their login. ...
(microsoft.public.sqlserver.security)