Post reply

Max number of records SQL Server 2000 can process

  • October 19, 2005 at 4:15 pm

    #111015

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

     

    Andy

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

  • 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

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

  • October 24, 2005 at 10:59 am

    #599597

    I think Phill answered my question.  Thank you.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply