Post reply

big transactions

  • July 12, 2007 at 9:41 am

    #173451

    I have a Win server with 8 processors (64 bits).

    How can I configure SQL Server 2005 to valid 2 millions of transactions in 2 hours max ?

    with partitioned tables, clustering, or another else ?


    Dom

  • July 12, 2007 at 12:21 pm

    #719070

    Clustering is not used for load balancing.

    When dealing with quantities like this it comes very much to having the proper hardware (CPU, memory and storage).  This in combination with the right query constructs and correct indexes.  Partitioning might indeed help if you have proper storage available.

Viewing 2 posts - 1 through 1 (of 1 total)

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