-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?

Improve this question
0

1 Answer 1

Reset to default
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.

Improve this answer
2
  • Here is some more info. sp_BlitzWho Version = '8.09', VersionDate = '20220408', SQL Server 2019 Standard Edition (RTM-CU16)
    – user2368632
    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
    Oct 6, 2022 at 12:33

Your Answer

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

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