DMVs impact on performance - SimonS Blog on SQL Server Stuff

DMVs impact on performance

Bottom line is very little if any. The way the SQLOS has been rearchitected the dmvs have been built into at the lowest level. This means the data exists, it is not a virtual table that is built up when the dmv is queried.

So go for it use the DMVs and understand what your server is actually doing.



-
Published 16 November 2006 02:58 by simonsabin

Comments

No Comments