{"id":10506,"date":"2017-09-29T13:32:22","date_gmt":"2017-09-29T11:32:22","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/"},"modified":"2017-09-29T13:32:22","modified_gmt":"2017-09-29T11:32:22","slug":"sql-server-2016-new-dynamic-management-views-dmvs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/","title":{"rendered":"SQL Server 2016: New Dynamic Management Views (DMVs)"},"content":{"rendered":"<p>In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs).<br \/>\nIn this article, I will just give you a little overview of these useful views for us as DBA.<\/p>\n<p>SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs.<br \/>\n<strong>Now, SQL Server 2016 has 185 DMVs.<br \/>\n<\/strong><\/p>\n<h3>How to see it?<\/h3>\n<p>It is very easy to have a look using the sys.all_objects view:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.all_objects WHERE TYPE=\u2019V\u2019 AND NAME LIKE \u2018dm_%\u2019 order by name ASC<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-18787 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\" alt=\"DMV_SQL2016\" width=\"300\" height=\"162\" \/><\/a><\/p>\n<p>From SQL Server 2012 to SQL Server 2014, we can notice that a lot of new DMVs comes with the In-Memory technology with the syntax &#8220;<strong>dm_xtp_<\/strong>xxxxxxxx&#8221; or &#8220;<strong>dm_db_xtp_<\/strong>xxxxxxxx&#8221;<\/p>\n<p>In SQL Server 2016, a lot of new &#8220;<strong>dm_exec_<\/strong>xxxxxxxx&#8221; is present.<\/p>\n<p>All definitions for these views come from the Microsoft documentation or web site.<\/p>\n<p>To begin, you will see <strong>10<\/strong> DMVs for the PolyBase technology:<\/p>\n<ul>\n<li><strong>dm_exec_compute_node_errors<\/strong>\n<ul>\n<li>Returns errors that occur on PolyBase compute nodes<\/li>\n<li><a title=\"dm_exec_compute_node_errors\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146380.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_compute_node_status<\/strong>\n<ul>\n<li>Give information about resources of PolyBase nodes like memory, cpu, time,&#8230;<\/li>\n<li><a title=\"dm_exec_compute_node_status\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146382.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_compute_nodes<\/strong>\n<ul>\n<li>Returns the list of type, logical name and IP adress of PolyBase nodes<\/li>\n<li><a title=\"dm_exec_compute_nodes\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt130700.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_distributed_request_steps<\/strong>\n<ul>\n<li>Give all steps that compose a PolyBase request<\/li>\n<li><a title=\"dm_exec_distributed_request_steps\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt130701.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_distributed_requests<\/strong>\n<ul>\n<li>Give the current status of actives queries<\/li>\n<li><a title=\"dm_exec_distributed_requests\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146385.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_distributed_sql_requests<\/strong>\n<ul>\n<li>This view shows the data for the last 1000 requests<\/li>\n<li><a title=\"dm_exec_distributed_sql_requests\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146390.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_dms_services<\/strong>\n<ul>\n<li>Give the status of the DMS (Data Movement Service) Service<\/li>\n<li><a title=\"dm_exec_dms_services\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146374.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_dms_workers<\/strong>\n<ul>\n<li>Show all workers completing DMS steps for the last 1000 queries and active queries<\/li>\n<li><a title=\"dm_exec_dms_workers\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146392.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_external_operations<\/strong>\n<ul>\n<li>returns information of external PolyBase operations<\/li>\n<li><a title=\"dm_exec_external_operations\" href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/mt146391.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_external_work<\/strong>\n<ul>\n<li>gives information for the workload per node<\/li>\n<li><a title=\"dm_exec_external_work\" href=\"https:\/\/msdn.microsoft.com\/en-US\/library\/mt146375.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>A useful msdn page resumes all DMVs for these new views <a title=\"Polybase DMVs\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt146389.aspx\" target=\"_blank\">here<\/a><\/p>\n<p>Other dm_exec_xxx views are basically usefull like:<\/p>\n<ul>\n<li><strong>dm_exec_function_stats<\/strong>\n<ul>\n<li>Returns aggregate performance statistics for cached functions.<\/li>\n<li><a title=\"dm_exec_function_stats\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt429371.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_query_optimizer_memory_gateways<\/strong>\n<ul>\n<li>Returns the current status of resource semaphores used to throttle concurrent query optimization.<\/li>\n<li><a title=\"dm_exec_query_optimizer_memory_gateways\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-exec-query-optimizer-memory-gateways\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_query_parallel_workers<\/strong>\n<ul>\n<li>Returns worker availability information per node<\/li>\n<li><a title=\"dm_exec_query_parallel_workers\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-exec-query-parallel-workers-transact-sql\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_exec_session_wait_stats<\/strong>\n<ul>\n<li>Returns information about all the waits encountered by threads that executed for each session<\/li>\n<li><a title=\"dm_exec_session_wait_stats\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-exec-session-wait-stats-transact-sql\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>3<\/strong> new DMVs for the Columstore technology:<\/p>\n<ul>\n<li><strong>dm_column_store_object_pool<\/strong>\n<ul>\n<li>Returns counts of different types of object memory pool usage for columnstore index objects<\/li>\n<li><a title=\"dm_column_store_object_pool\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-column-store-object-pool-transact-sql\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_db_column_store_row_group_operational_stats<\/strong>\n<ul>\n<li>Returns current row-level I\/O, locking, and access method activity for compressed rowgroups in a columnstore index.<\/li>\n<li><a title=\"dm_db_column_store_row_group_operational_stats\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-db-column-store-row-group-operational-stats-transact-sql\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_db_column_store_row_group_physical_stats<\/strong>\n<ul>\n<li>Provides current rowgroup-level information about all of the columnstore indexes in the current database<\/li>\n<li><a title=\"dm_db_column_store_row_group_operational_stats\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-db-column-store-row-group-physical-stats-transact-sql\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>2<\/strong> new DMVs for Stretch Databases in the database context and with rda(remote database archive):<\/p>\n<ul>\n<li><strong>dm_db_rda_migration_status<\/strong>\n<ul>\n<li>To list the migration batch of the table<\/li>\n<li>See Nathan Courtine Article <a title=\"Nathan Courtine Article\" href=\"http:\/\/dbi-services.com\/blog\/manipulate-stretch-database-feature-by-script\/\">here<\/a><\/li>\n<li><a title=\"dm_db_rda_migration_status\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn935017.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><strong>dm_db_rda_migration_status<\/strong>\n<ul>\n<li>For the current database, list of state information of the remote data archive schema update task.<\/li>\n<li><a title=\"dm_db_rda_migration_status\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt604378.aspx\">Microsoft Reference here<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>This list can change if a Service Pack is\u00a0 applied.<br \/>\nIt is just for you to have a little reference view about these useful views! \ud83d\ude0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs. Now, SQL Server 2016 has 185 DMVs. How to [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":10507,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[49,51,566,44],"type_dbi":[],"class_list":["post-10506","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","tag-microsoft","tag-sql-server","tag-sql-server-2016","tag-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016: New Dynamic Management Views (DMVs) - dbi Blog<\/title>\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-2016-new-dynamic-management-views-dmvs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: New Dynamic Management Views (DMVs)\" \/>\n<meta property=\"og:description\" content=\"In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs. Now, SQL Server 2016 has 185 DMVs. How to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-29T11:32:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1099\" \/>\n\t<meta property=\"og:image:height\" content=\"594\" \/>\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-2016-new-dynamic-management-views-dmvs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: New Dynamic Management Views (DMVs)\",\"datePublished\":\"2017-09-29T11:32:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/\"},\"wordCount\":564,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2016\",\"Troubleshooting\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/\",\"name\":\"SQL Server 2016: New Dynamic Management Views (DMVs) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\",\"datePublished\":\"2017-09-29T11:32:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png\",\"width\":1099,\"height\":594},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: New Dynamic Management Views (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 2016: New Dynamic Management Views (DMVs) - dbi Blog","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-2016-new-dynamic-management-views-dmvs\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: New Dynamic Management Views (DMVs)","og_description":"In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs and SQL Server 2014 has 166 DMVs. Now, SQL Server 2016 has 185 DMVs. How to [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/","og_site_name":"dbi Blog","article_published_time":"2017-09-29T11:32:22+00:00","og_image":[{"width":1099,"height":594,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.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-2016-new-dynamic-management-views-dmvs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: New Dynamic Management Views (DMVs)","datePublished":"2017-09-29T11:32:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/"},"wordCount":564,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png","keywords":["Microsoft","SQL Server","SQL Server 2016","Troubleshooting"],"articleSection":["Database Administration &amp; Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/","name":"SQL Server 2016: New Dynamic Management Views (DMVs) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png","datePublished":"2017-09-29T11:32:22+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/DMV_SQL2016.png","width":1099,"height":594},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-dynamic-management-views-dmvs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: New Dynamic Management Views (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\/10506","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=10506"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10506\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10507"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10506"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}