Thanks Simon. And you are correct, I do not work in any bank or anything
close to a bank.

JD

"Simon Hayes" <sql@hayes.ch> wrote in message
news:4213c39e_2@news.bluewin.ch...
>
> "JD" <joeydba@yahoo.com> wrote in message
news:4213bdfd$1@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
>
>