• 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.