Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Table Partitioning as it relates to table escalation Expand / Collapse
Posted Friday, April 25, 2014 5:38 PM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 27, 2016 4:32 PM
Points: 388, Visits: 422
In SQL 2005, can I partition a table to help with more row and page locks versus immediately jumping to table locks?

I have one table that seems to always table lock on every transaction. Will partitioning that table help with partition locks, or do I need the application team to alter the code on app side to understand the table is partitioned? My bosses are talking about turning on trace flags (1211 or 1224) and doing other things that I would rather not try until I have ruled out all other options.
Post #1565257
Posted Saturday, April 26, 2014 7:54 AM



Group: General Forum Members
Last Login: Today @ 4:50 PM
Points: 23,515, Visits: 37,731
Before you start looking at partitioning you may want to look at the code that is forcing the table locks and the current indexing (clustered/nonclustered) on the table.

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1565319
Posted Saturday, April 26, 2014 7:56 AM



Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 45,616, Visits: 44,144
Start by tuning the queries. Partitioning is not a silver bullet.

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

Post #1565320
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse