SEO

#1 (**permalink**) 02-29-2008, 06:12 AM

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

#2 (**permalink**) 02-29-2008, 06:12 AM

"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

#3 (**permalink**) 02-29-2008, 06:12 AM

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
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL 2000 whitepaper?