Sql server 2000 Locking
-
Which is better for concurrency, non escalating lock and data integrity RowLock or UPDLOCK.
environment high transaction volume(1000/per min) (for Inserts, Updates and selects)
updating/selecting in most cases one or several records and inserting a record to different tables.
-
For what? Inserts, Updates, Deletes, or Selects?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
note that technically a select is not a transaction as it doesn't change data. Umm 1000 transactions/min ( did you mean minute? ) is not even low volume really and certainly not high!.
On the other side of the counter, poor code/design/strategy at 2 transactions/sec can seriously screw your server, whereas a good setup may run at several k on the same hardware etc. etc.
As Jeff says, for what and why? do you have a problem?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Yeah.. that's what I was kinda getting at... if it's all SELECTs, what's the problem
Also, what I've found is that a lot of folks use a transaction table also as a batch table and wonder why the world freezes why they do major processing on the table.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply