471,055 Members | 2,059 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,055 software developers and data experts.

SQL 2000 whitepaper?

JD
Is there a whitepaper or other documentation that talks about SQL2000
performance limits?
For example, transaction/sec limit? (Which I understand that hardware config
would be a factor)

thanks
Jul 23 '05 #1
2 1115

"JD" <jo*****@yahoo.com> wrote in message news:42********@news.qgraph.com...
Is there a whitepaper or other documentation that talks about SQL2000
performance limits?
For example, transaction/sec limit? (Which I understand that hardware
config
would be a factor)

thanks


Google "sql 2000 performance" and/or see here:

http://www.sql-server-performance.com/

As for a 'limit' on transactions/sec, see here:

http://www.tpc.org/

According to TPC, MSSQL 2000 can do 768,646 transactions/minute in an OLTP
configuration, assuming you have the best hardware and the best tuning
experts available, but that probably has no relevance to your own
environment anyway. In general, unless you are running a large bank, MSSQL
can do what you want; if you are running a large bank, then you probably
don't need to post in newsgroups to get information...

Simon
Jul 23 '05 #2
JD
Thanks Simon. And you are correct, I do not work in any bank or anything
close to a bank.

JD

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:42********@news.bluewin.ch...

"JD" <jo*****@yahoo.com> wrote in message

news:42********@news.qgraph.com...
Is there a whitepaper or other documentation that talks about SQL2000
performance limits?
For example, transaction/sec limit? (Which I understand that hardware
config
would be a factor)

thanks


Google "sql 2000 performance" and/or see here:

http://www.sql-server-performance.com/

As for a 'limit' on transactions/sec, see here:

http://www.tpc.org/

According to TPC, MSSQL 2000 can do 768,646 transactions/minute in an OLTP
configuration, assuming you have the best hardware and the best tuning
experts available, but that probably has no relevance to your own
environment anyway. In general, unless you are running a large bank, MSSQL
can do what you want; if you are running a large bank, then you probably
don't need to post in newsgroups to get information...

Simon

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Dagwood | last post: by
10 posts views Thread by noname | last post: by
2 posts views Thread by Scott | last post: by
3 posts views Thread by Steve Baer | last post: by
5 posts views Thread by Mo | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.