-1

Running sp_blitzwho @GetLiveQueryPlan = 1 on SQL2019 to monitor a big index rebuild operation but running into the following error:

Lock request time out period exceeded.

Anything I can do to avoid this error?

0

1 Answer 1

4

Make sure you're on the latest version of sp_BlitzWho. This issue was reported and fixed over a year ago in this Github issue.

If you're on the latest version, and you're still experiencing the error, that means SQL Server isn't honoring isolation level requests in the DMVs. This wouldn't be the first time we've run into this issue, unfortunately - you would need to contact Microsoft support.

2
  • Here is some more info. sp_BlitzWho Version = '8.09', VersionDate = '20220408', SQL Server 2019 Standard Edition (RTM-CU16) Commented Oct 4, 2022 at 15:59
  • @user2368632 we won't be doing more troubleshooting here in the comments. As I wrote earlier, you would need to contact Microsoft support.
    – Brent Ozar
    Commented Oct 6, 2022 at 12:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.