{"id":2348,"date":"2011-11-17T08:04:00","date_gmt":"2011-11-17T07:04:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/"},"modified":"2011-11-17T08:04:00","modified_gmt":"2011-11-17T07:04:00","slug":"sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/","title":{"rendered":"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs"},"content":{"rendered":"<p>For a few months, I have been testing the new\u00a0 SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance. I will focus on some DMVs which are very interesting for a DBA.<\/p>\n<p>My article is based on a msdn web site reference. At the end of each chapter, you will find a msdn reference for more details on the DMV.<\/p>\n<h3>sys.dm_exec_query_stats<\/h3>\n<p>dm_exec_query_stats is not a new view but this view adds a few columns very important :<\/p>\n<ul>\n<li>total_rows : Total number of rows returned by the query<\/li>\n<li>last_rows : Number of rows returned by the last execution of the query<\/li>\n<li>min_rows : Minimum number of rows returned by the query over the number of times that the plan has been executed since it was last compiled.<\/li>\n<li>max_rows : Maximum number of rows returned by the query over the number of times that the plan has been executed since it was last compiled.<\/li>\n<\/ul>\n<p>Example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png\" alt=\"01-dm_exec_query_stats\" width=\"586\" height=\"432\" \/><\/p>\n<p>Msdn reference: <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms189741(v=SQL.110).asp\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms189741(v=SQL.110).asp<\/a><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms189741(v=SQL.110).aspx\">x<\/a><\/p>\n<h3>sys.dm_os_volume_stats<\/h3>\n<p>dm_os_volume_stats is a view for the operating system\u2019s volume information.<br \/>\nThis view exists on the version 2008 R2 but was not well known.<\/p>\n<p>Two arguments are necessary:<\/p>\n<ul>\n<li>ID of the database<\/li>\n<li>ID of the file<\/li>\n<\/ul>\n<p>To find the 2 arguments, you can use:<\/p>\n<p style=\"padding-left: 30px;\"><code>SELECT * FROM sys.master_files;<\/code><\/p>\n<p>Example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/02-dm_os_volume_stats.png\" alt=\"02-dm_os_volume_stats\" width=\"662\" height=\"214\" \/><\/p>\n<p>Msdn reference : <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh223223.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/hh223223.aspx<\/a><\/p>\n<h3>sys.dm_os_windows_info<\/h3>\n<p>This view returns all information on Windows operation system like release, service pack, and language version. Like dm_os_volume_stats, this view exist on SQL Server 2008 R2.<\/p>\n<p>Example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/03-dm_os_windows_info.png\" alt=\"03-dm_os_windows_info\" width=\"512\" height=\"152\" \/><br \/>\nMsdn reference:<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh204565.aspx\"> http:\/\/msdn.microsoft.com\/en-us\/library\/hh204565.aspx<\/a><\/p>\n<h3>sys.dm_server_services<\/h3>\n<p>This view returns information about your SQL Server services in the current instance. With this DMV you will just get information on the SQL Server Engine, the SQL Server Agent, and the SQL full-text daemon. I hope that we will see information\u00a0 on SSAS, SSIS, and SSRS in the future.<br \/>\nLike the 2 precedent views, it is available on SQL Server 2008 R2.<\/p>\n<p>Example:<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/04-dm_server_services.png\" alt=\"04-dm_server_services\" width=\"682\" height=\"87\" \/><\/p>\n<p>Msdn reference: <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh204565.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/hh204565.aspx<\/a><\/p>\n<h3>sys.dm_server_registry<\/h3>\n<p>This view return information on the registry configuration of SQL Server&#8217;s current instance.<br \/>\nYou will get all information on registry keys. For me, it&#8217;s a good feature for audit the configuration server. It&#8217;s running on SQL Server 2008 R2.<\/p>\n<p>Example:<br \/>\n<img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/05-dm_server_registry.png\" alt=\"05-dm_server_registry\" width=\"678\" height=\"330\" \/><\/p>\n<p>Msdn reference: <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh204561.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/hh204561.aspx<\/a><\/p>\n<h3>sys.dm_server_memory_dumps<\/h3>\n<p>This view returns all memory dump file that are\u00a0 generated. I have not dumped files on my example but you can see whitch colunms are returned.<br \/>\nIt is running on SQL Server 2008 R2.<\/p>\n<p>Example:<br \/>\n<img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/06-dm_server_memory_dumps.png\" alt=\"06-dm_server_memory_dumps\" width=\"324\" height=\"112\" \/><br \/>\nMsdn reference:<a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh204543.aspx\"> http:\/\/technet.microsoft.com\/en-us\/library\/hh2045<\/a><a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh204543.aspx\">43.aspx<\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>The majority of these new views announced for SQL Server 2012 are already part of\u00a0 SQL Server 2008 R2.<br \/>\nBut it is good to know that these features exist. I found them quite interesting and have included them in my SQL Server audit tool.:-D<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.<br \/>Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.<br \/>I will just explain some DMVs very interesting for a DBA. <br \/>My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.<\/p>\n","protected":false},"author":15,"featured_media":2349,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[262,280,23,293,263,49,264,265,54],"type_dbi":[],"class_list":["post-2348","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-analysis-services","tag-database","tag-dba","tag-denali","tag-integration-services","tag-microsoft","tag-reporting-services","tag-sql-server-2008","tag-sql-server-2012"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs - dbi Blog<\/title>\n<meta name=\"description\" content=\"or a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. I will just explain some DMVs very interesting for a DBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs\" \/>\n<meta property=\"og:description\" content=\"or a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. I will just explain some DMVs very interesting for a DBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-17T07:04:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"567\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs\",\"datePublished\":\"2011-11-17T07:04:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/\"},\"wordCount\":541,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/01-dm_exec_query_stats.png\",\"keywords\":[\"Analysis services\",\"database\",\"DBA\",\"Denali\",\"Integration services\",\"Microsoft\",\"Reporting services\",\"SQL Server 2008\",\"SQL Server 2012\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/\",\"name\":\"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/01-dm_exec_query_stats.png\",\"datePublished\":\"2011-11-17T07:04:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"or a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. I will just explain some DMVs very interesting for a DBA.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/01-dm_exec_query_stats.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/01-dm_exec_query_stats.png\",\"width\":768,\"height\":567},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs - dbi Blog","description":"or a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. I will just explain some DMVs very interesting for a DBA.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs","og_description":"or a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. I will just explain some DMVs very interesting for a DBA.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/","og_site_name":"dbi Blog","article_published_time":"2011-11-17T07:04:00+00:00","og_image":[{"width":768,"height":567,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs","datePublished":"2011-11-17T07:04:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/"},"wordCount":541,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png","keywords":["Analysis services","database","DBA","Denali","Integration services","Microsoft","Reporting services","SQL Server 2008","SQL Server 2012"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/","name":"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png","datePublished":"2011-11-17T07:04:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"or a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. I will just explain some DMVs very interesting for a DBA.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/01-dm_exec_query_stats.png","width":768,"height":567},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-u2018denaliu2019-a-new-panel-of-dmvs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012 \u2018Denali\u2019: a new panel of DMVs"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2348"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2348\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2349"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2348"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}