Thanks a lot Jeff. Many many thanks.

I have few follow-up questions.

1. Why a unique non-clustered index ? why not just a non-clustered index for [NI_APPLIED_LOCK_SBL3R8]. Because I don't know the...

Thanks Jeff. Even I was surprised that , why would they even trying to implement the locking mechanism as sql does take care of it.

CREATE TABLE [dbo].[C_REPOS_APPLIED_LOCK] (

[ROWID_LOCK] [nchar](14) NOT...

Thanks a lot Grant for the guidance. Many thanks.

Hi Grant,

Need one help. Suppose if we had to collect all the surrounding info. How would be my extended trace should be configured ? The above information I collected from...

Thanks Grant. Will check with the dev team. Thanks for the help.

<deadlock>
  <victim-list>
    <victimProcess id="process237485b868" />
  </victim-list>
  <process-list>
    <process id="process237485b868" taskpriority="0" logused="0" waitresource="KEY: 34:72058363954855936 (e795f34fdfa7)" waittime="503" ownerId="9642762791" transactionname="implicit_transaction" lasttranstarted="2019-08-22T22:36:51.997"...

Thanks for the explanation.

Thanks Jeffrey Williams. Thanks for the link as well.

Hi Alex,

Its is a full backup. Don't know the reason why , when backup is in progress , it was showing the backup file size as 822 GB but after...

Thank you All.

Thank you for providing the information.

Thanks Andrey and Grant.

Thanks everyone for the value suggestions.

Thanks Jonathan.

Scott, in what way page compression can help here? does it again cause cpu spike? does it need repetitive data?