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

[Simon Hayes]

"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

[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