There is a large object causing heavy locking but I am unable to identify which individual statement or batch is causing it.
The static binary files used by Peformance Analysis for SQL Server are most likely full as a result. Either there are more new statements and batches being recorded than it can clean out or the sizes of the statements are very large and occupying large amounts of the binary file therefore preventing smaller, more numerous statements from being displayed. Read through the attached technical article for a more in-depth explanation of the behaviour experienced.
The solution is to increase the binary file size to accommodate the statements load. The attached technical article goes through the steps necessary.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center