Max number of records SQL Server 2000 can process

• arussell_10

  SSCrazy

  Points: 2110

  More actions

  October 19, 2005 at 4:15 pm

  #111015

  Is there a maximum number of records SQL Server 2000 can process in a second?

   

  Andy

• dmanju

  Say Hey Kid

  Points: 685

  More actions

  October 19, 2005 at 5:59 pm

  #598541

  I dont think there is any such limit. The number of records SQL Server 2000 can process in a second is dependent on the number of processors, the load on the server, available memory and the size of the records and other such factors...

• philcart

  SSC-Forever

  Points: 47797

  More actions

  October 19, 2005 at 6:48 pm

  #598548

  To get an idea of the numbers possible given an appropriate setup, take a look at the results posted at http://www.tpc.org

  The current price/performance leader is a SQL Server 2005 64bit system running on Windows Server 2003 64bit. This setup has a throughput of 38,622 tpmC and cost a little over US$38k.

  http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=105092601

  The leader in terms of transactions is a SQL Server 2005 Enterprise Edition 64bit system running on Windows Server 2003 Datacenter 64bit. This setup has a throughput of over 1 million tpmC but at the slightly prohibitive cost of over US$5.8mil.

  http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=105060604

   

  --------------------
  Colt 45 - the original point and click interface

• WiredUK

  Old Hand

  Points: 300

  More actions

  October 20, 2005 at 3:22 am

  #598598

  It also depends on what you mean by "process". INSERT, SELECT, DELETE?

  And they are all affected by indexes, hardware etc.

• arussell_10

  SSCrazy

  Points: 2110

  More actions

  October 24, 2005 at 10:59 am

  #599597

  I think Phill answered my question.  Thank you.