![]() ![]() There may be a tendency to focus on server-side tuning and platform issues when facing a blocking problem. In contrast, the second situation results in a consistent state that can be easier to diagnose. These situations are difficult to troubleshoot using SQL Server Management Studio to narrow down the issue to individual queries. In the first scenario, the situation can be very fluid as different SPIDs cause blocking on different resources over time, creating a moving target. This type of blocking doesn't resolve itself and prevents access to the affected resources indefinitely. This type of blocking resolves itself over time but can cause performance degradation.Īn SPID holds locks on a set of resources and never releases them. When locking and blocking persists to the point where there's a detrimental effect on system performance, it's due to one of the following reasons:Īn SPID holds locks on a set of resources for an extended period of time before releasing them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |