Is it alright to use NOLOCK with DMVs? I was recently asked about this by a client during the Comprehensive Database Performance Health Check.
They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.
Question: Does NOLOCK Really Applies No Lock?
Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct.