[Campaign Classic] Enhancement Request: Application-level throttling and lock diagnostics for concurrent SQL Server write workloads

Problem statement:
Customers encountering blocking and duplicate-key failures during concurrent Update Data or registration-style operations currently have no Adobe-supported product feature to smooth write contention. Public guidance focuses on maintenance and scheduling, and product guidance does not recommend enabling SQL Server RCSI. ACC should provide native controls and diagnostics to reduce lock contention without requiring unsupported database isolation changes.

Request:

Provide native concurrency controls for ACC write-heavy operations on SQL Server so customers can reduce blocking and duplicate-key failures without changing unsupported database isolation settings.

Possible sub-features:

• Queue/throttle mode configurable queuing/throttling for high-concurrency write paths, including registration or subscription-style calls
• Conflict-aware workflow scheduling/locking hints for Update Data activities targeting the same dataset; lock-aware diagnostics and admin visibility
• Application metrics showing lock wait hot spots, duplicate-key retry counts, and top blocking transaction patterns
• Admin-level safeguards warning/guardrails for overlapping conflicting workflows, likely to contend on the same target table/list