Post reply

Partitioned Table Practices

  • July 3, 2014 at 9:16 am

    #397003

    Hi,

    When DBA's partition tables, what are some of the things they look at to determine the number of partitions, files, file sizes, and file groups.

    Thanks

  • July 3, 2014 at 9:21 am

    #1726876

    The first thing would be what the point of the partitioning is

    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

  • July 7, 2014 at 8:18 am

    #1727385

    I have a 14 million record table that gets frequent updates, inserts, and reads from reports. I'm trying to find a way to improve the performance and reduce blocking\locking. Ideally we should probably separate OLAP and OLTP but business is not willing to spend the money. Thanks.

  • July 7, 2014 at 8:52 am

    #1727416

    Then don't waste your time looking at partitioning. Indexing along with tuning the queries should be your approach there.

    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

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

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