Partitioned Table Practices

• smallmoney

  SSCarpal Tunnel

  Points: 4378

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• smallmoney

  SSCarpal Tunnel

  Points: 4378

  More actions

  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.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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