DEGRADED MODE — CACHED ENTITLEMENTS · SENTRIS-DB01 UNREACHABLE · People & Places duty desk
Modify ↓

Opened 14 years ago

Last modified 14 years ago

#5 RESOLVED fault

SQL Server deadlocks on the CMS database during the nightly KPI roll-up

Reported by: People & Places Owned by: M. Ross (Infrastructure)
Priority: P3 Milestone:
Component: Infrastructure / Database Version:
Keywords: Cc:
Desk: Estate & Systems Legacy ref: DEVCON-0620

Description

The nightly KPI roll-up job intermittently deadlocks against the live CMS writes, occasionally failing the coverage report the client sees each morning. Classic lock-ordering contention between the reporting read and the telemetry insert.

Attachments (0)

Change History (2)

comment:1 by M. Ross, 14 years ago

Two transactions taking the same tables in opposite order. Added the missing covering index and moved the roll-up to snapshot isolation.

comment:2 by M. Ross, 14 years ago

Five clean nights, no deadlocks, report out on time. Closing.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as RESOLVED The owner will remain M. Ross (Infrastructure).

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.