June 6, 2002 at 3:04 pm
Can anyone tell me how many transactions per second or minute SQL 7.0 can handle. I get the feeling its about 40.
Thanks
Aurora
June 6, 2002 at 8:08 pm
Actually there are a lot of factors that affect this, hardware and design wise. If I remember correctly Microsoft has a stats for the big DB transaction (TPC) for sql 2000 test where it was in the hundreads of thousands per minuite, but I cannot find the 7 stats which were not too far off.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 7, 2002 at 6:30 am
It also will vary widely depending on both your definition of a "transaction" and the complexity of said transaction, combined as Antares mentioned with hardware plus how well tuned the server/database is. Are you having a problem supporting x transactions per min, or trying to plan for future requirements?
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply