One of our 3rd Party Production system went through a major upgrade and with sp_whoisactive I'm now seeing a lot of queries - 1 transaction deep - that are blocking any of my attempts to read dm_db_missing_index_details.
I've tried setting the TRANSACTION ISOLATION LEVEL and using NOLOCK, but SQL just laughs in my face.
Hannah Vernon was able to replicate this behavior here.
Does anyone know how to get round this issue?
We experienced some odd blocking with the system last week and Redgate Intellisense was part of the blocking chain, are there any other DMVs that also have the same issue?