We don't have deadlocks yet. But this is a new design so i am trying to come up with a solution so that it will not fall as victim of...

Any thoughts?

You're right. Thanks Sue!

Sometime resource monitor also helps. Did you check that?

Does table partitioning supported with the JSON blob structures?

Any advise?

Also wanted to add to the above, that the master table will have data with pointers to pdf or other document type which are located in the file system. The...

Any thoughts?

Any thoughts? Thanks in advance!

Thanks Michael John. So keeping in considering with license cost and performance benefit. Would below setup sounds reasonable to you?

Primary Replica - Full, Diff and Log backups & Maintenance Jobs...

Does SQL Server do a page lock and is that normal behavior if it is getting a large amount of inserts/update and the fill factor is set to above 80%?

Thanks Grant. I really appreciate for helping me with this. Yes it is a classic deadlock problem . Actually we have only one table and just one simple update. So...

They are both different process id. However, i do see that the updates are coming from two different app servers, app server1 is the victim query and from app server2...

Thanks for the info. Sorry about not providing enough information. So i captured the deadlock and i find the two statements are same which is Update statement. So i see...

Also found the table name and the index name which is a primary key and it's a simple update statement with updae lock (U). So what are the options to...