New Dynamic Management Views (DMVs) New Dynamic Managemtn Views in SQL Server 2012 ------------------------------ 1) select * from sys.dm_server_services This query fetches in…