Dear SQL Server Experts,
I am basically from Oracle DBA background and I don't have much experience in SQL Server. I hope I will get some experts advise and comments on my SQL Server DB issue :)ert
We have MS CRM DB with the size of 350 GB. We're experiencing DB locks (blocking) issue on production SQL DB. As per MS article "“Blocking is an unavoidable characteristic of any relational database management system (RDBMS) with lock-based concurrency”. Having blockings detected is not by itself enough and sufficient to decide the problem"".
1. what was the reason for blocking?
2.any advice on optimizing that particular cause?
3. Is there any chance of more blocking if I use more NOLCOK DB hint in update or insert or select operations ?