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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.