Post reply

Sql Server Partitioning

  • August 21, 2013 at 9:49 am

    #297129

    Hi Everyone,

    I'm running Sql Server 2008 R2 and I'm configuring table partitioning for 3 tables.

    My question is, what is the recommended approach - to create one partition scheme and one partition function on each table, or one scheme and one function that is then used to partition all the tables?

    The partition key is the same on each table and the table row counts are:

    Table1 = 60 million records

    Table2 = 20 million records

    Table3 = 100 million records

    Thanks in advance.

    www.sqlAssociates.co.uk

  • August 22, 2013 at 4:18 am

    #1643828

    Hi Chris,

    The below thread may give you bit more information...

    http://www.sqlservercentral.com/Forums/Topic1460020-391-1.aspx

  • August 22, 2013 at 4:31 am

    #1643832

    What are you partitioning for? What's the goal?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2013 at 4:38 am

    #1643838

    Hi Gail,

    We are hoping to...

    # Be able to mange our data in smaller more manageable chunks.

    # Be able to manage index maintenance on the table more efficiently.

    # Archive data more efficiently.

    # Prepare for a massive data volume increase (for which the business cannot be specific in terms of number of rows).

    Thanks.

    www.sqlAssociates.co.uk

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

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