August 13, 2002 at 10:27 am
This is an easy one, but I am having trouble finding the documentation.
How many transactions per minute can SQL 7.0 handle?
Thanks
Chris
Aurora
August 13, 2002 at 5:12 pm
The number of transactions per minute that SQL Server 7 can process varies. There is no one published number for this. How many transactions per minute you can get out of your systems depends on the hardware, type of transactions (insert, delete, select, update) and how good or bad the SQL coding for the app you are using is and other factors. The only way to get a real number for your system is to test it yourself.
Diane
August 13, 2002 at 5:33 pm
Totally agree. Its a lot of variables, too many to be worth trying to guess, better to just test.
Andy
August 13, 2002 at 9:25 pm
If you go out and visit:
you'll see quite a range in SQL Server 2000 performance, and this is mainly due to the different hardware ranges, even though the test is the same.
For instance, if you look at the top 3 results for performance, you'll see SQL 2K for each of these three. However, the range in tpmC is almost 142,000, and this is only for the top 3.
K. Brian Kelley
http://www.truthsolutions.com/
K. Brian Kelley
@kbriankelley
August 14, 2002 at 6:57 am
Yes, I understand and agree, I was just hoping there was documentation or benchmarks for SQL 7.0. I have already done my own testing and wanted further documentation to support my recommendation of upgrading our replicating dB's to SQL 2000.
Thanks Brian, I checked out that site and it had some interesting information. Thanks all, I should have been more clear on what I was looking for.
Thanks again,
Christine
Aurora
August 14, 2002 at 11:31 am
If you have a Microsoft rep, you may want to contact them. Microsoft used to have performance information on their site for SQL Srever 7, but it's now all SQL Server 2000.
K. Brian Kelley
http://www.truthsolutions.com/
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply