Allpages-locked heap tables that have large amounts of concurrent insert activity will benefit from partitioning. Insert rates must be very high before significant blocking takes place on data-only-locked tables. If you are not sure whether the tables in your database system might benefit from partitioning:
Use sp_sysmon to look for last page locks on heap tables.
See “Lock management”.
Use sp_object_stats to report on lock contention.