OLTP transactions performance benchmarks

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

OLTP transactions performance benchmarks

Author

Topic

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-04-07 : 06:09:33

What should be OLTP transactions performance benchmarks and How to achive them ???

I am gonna summrise it:
What should the numbers of transactions per second ? (for OLTP & RSS)
What should the response time (transaction processing time) (for OLTP & RSS)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-07 : 16:50:48

On our largest system, we get up to 5000 queries per second. But we have very expensive hardware for this. On that system, we expect 95% of queries to complete in 300 milliseconds or less. Your mileage will vary depending upon hardware, database design, query design, and data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-04-08 : 05:46:05

Thanks for your reply...
Trasaction Processing Performance Council recommends
HP Integrity Superdome - Itanium2/1.6 GHz-64p/64c (http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms)
to achieve >10000 queries per second performance. But its too expensive.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources