in

SQL Server Community Blogs

Voices of the SQL Server Community

Browse by Tags

  • 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. ...
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems