Citrix deadlock

Tuning 3rd party databases is not what I’d like to spend time on, but this Citrix database keeps deadlocking on this procedure: chb_Config.chb_UpsertLeases.

This was resolved by adding included columns to the index, to avoid a bookmark lookup.


CREATE UNIQUE NONCLUSTERED INDEX [IX_Leases_LeaseKey]
ON [chb_State].[Leases]( [LeaseKey] ASC)
INCLUDE ( [IsMarkedForDeletion], LeaseChecksum, UserUid, LastModifiedTime)
WITH (DROP_EXISTING = ON)
GO

Advertisements
Quote | This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s