{"id":11238,"date":"2018-05-11T14:23:13","date_gmt":"2018-05-11T12:23:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/"},"modified":"2018-05-11T14:23:13","modified_gmt":"2018-05-11T12:23:13","slug":"sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/","title":{"rendered":"SP2 for SQL Server 2016 is available with new helpful DMVs"},"content":{"rendered":"

Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016<\/a> was released and distributed.
\nThis Service Pack has new DMVs, already available in SQL Server 2017 RTM.<\/p>\n

In this article, I will just write few words about 2 DMVs (sys.dm_db_log_stats & sys.dm_db_log_info<\/strong>) and a new column (modified_extent_page_count<\/strong>) in the DMV sys.dm_db_file_space_usage<\/strong> that I presented during our last event about SQL Server 2017. I think they are really helpful for DBA.
\nIt\u2019s also the opportunity to present you the demo that I create for our Event.<\/p>\n

Preparation<\/h3>\n

First, I create the database smart_backup_2016 and a table Herge_Heros<\/p>\n

CREATE DATABASE [smart_backup_2016]\n CONTAINMENT = NONE\n ON  PRIMARY\n( NAME = N'smart_backup_2016', FILENAME = N'G:\\MSSQL\\Data\\smart_backup_2016.mdf' )\n LOG ON\n( NAME = N'smart_backup_2016_log', FILENAME = N'G:\\MSSQL\\Log\\smart_backup_2016_log.ldf' )\nGO\n\nUSE smart_backup_2016\nGO\n\nCREATE TABLE [dbo].[Herge_Heros]\n   (\n   [ID] [int] NULL,\n   [Name] [nchar](10) NULL\n   ) ON [PRIMARY]\nGO<\/pre>\n
I do a little insert and run a first Full and a first TLog Backup<\/p>\n
INSERT INTO [Herge_Heros] VALUES(1,'Tintin') -- Tim\nINSERT INTO [Herge_Heros] VALUES(2,'Milou') -- Struppi\n\n\nBACKUP DATABASE [smart_backup_2016] TO  DISK = N'C:\\Temp\\smart_backup.bak' WITH NOFORMAT, NOINIT,  NAME = N'smart_backup-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10\nGO\nBACKUP Log [smart_backup_2016] TO  DISK = N'C:\\Temp\\smart_backup.log' WITH NOFORMAT, NOINIT,  NAME = N'smart_backup-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10\nGO<\/pre>\n
After, I insert a lot of line to have more than 50% modified pages<\/p>\n
INSERT INTO [Herge_Heros] VALUES(3,'Quick') --Strups\nINSERT INTO [Herge_Heros] VALUES(4,'Flupke')  --Stepppke\nGO 100000<\/pre>\n
Now, the demo is ready!<\/p>\n
new column modified_extent_page_count in sys.dm_db_file_space_usage<\/h3>\n
\"smart_backup01\"<\/a>
\nAs you can see in this screenshot, the column is really existing in SQL Server 2016 SP2 (13.0.5026.0).
\nAfter, you can, like us in our DMK maintenance, create an adapted Backup Strategy depending from changes and no more depending from the time.
\nIn this stored procedure, if the modified pages are greater than 50% of the total pages, it will do a Full Backup and if the modified pages are less than 50%, it will do a Differential Backup.<\/p>\n
USE [dbi_tools]\nGO\n\nCREATE or ALTER PROCEDURE [maintenance].[dbi_smart_backup] @database_name sysname\nas\nDECLARE @pages_changes Numeric(10,0)\nDECLARE @full_backup_threshold INT\nDECLARE @diff_backup_threshold INT\nDECLARE @sql_query nvarchar(max)\nDECLARE @page_change_text nvarchar(20)\nDECLARE @param nvarchar(50)\nDECLARE @backupfile nvarchar(2000)\nSET @full_backup_threshold=50\nSET @diff_backup_threshold=0\nSET @param = N'@pages_changesOUT nvarchar(20) OUTPUT'\nSET @sql_query =N'SELECT @pages_changesOUT=( 100 * Sum(modified_extent_page_count) \/ Sum(total_page_count) ) FROM ['+@database_name+'].sys.dm_db_file_space_usage'\n\nEXECUTE sp_executesql @sql_query,@param ,@pages_changesOUT=@page_change_text OUTPUT; \nSET @pages_changes = CAST(@page_change_text AS Numeric(10,0)) \nIF @pages_changes > @full_backup_threshold\n  BEGIN\n     --Full Backup threshold exceeded, take a full backup\n     Print 'Full Backup Threshold exceeded, take a full backup'\n     SET @backupfile = N'C:\\Temp\\'+@database_name+N'_' + replace(convert(nvarchar(50), GETDATE(), 120), ':','_') + N'.bak'\n   BACKUP DATABASE @database_name TO DISK=@backupfile\n  END\n  ELSE\n  BEGIN\n\t   IF @pages_changes >= @diff_backup_threshold\n\t\tBEGIN\n\t\t\t-- Diff Backup threshold exceeded, take a differential backup\n\t\t\tPrint 'Diff Backup threshold exceeded, take a differential backup'\n\t\t\tSET @backupfile = N'C:\\Temp\\'+@database_name+N'_' + replace(convert(nvarchar(50), GETDATE(), 120), ':','_') + N'.dif'\n\t\t\tBACKUP DATABASE @database_name TO DISK=@backupfile WITH differential\n\t\tEND\n\tELSE\n\t\tBEGIN\n\t\t\t-- No threshold exceeded, No backup\n\t\tPRINT 'No threshold exceeded, No backup'   \n\t\tEND\n  END\nGO<\/pre>\n
Now, I run the stored procedure [maintenance].[dbi_smart_backup] in the dbi_tool<\/p>\n
USE smart_backup_2016;\nGO\nEXEC [dbi_tools].[maintenance].[dbi_smart_backup] @database_name = N'smart_backup_2016'<\/pre>\n
\"smart_backup02\"<\/a>
\nThe dbi backup Stored Procedure in this case do a Full Backup because the modified pages are 64%.
\nI check the status of the modified pages and the modified pages are at 5%.
\n\"smart_backup03\"<\/a>
\nIf I restart the stored procedure, I do a differential backup.
\n\"smart_backup04\"<\/a>
\nMy backup strategy is really adapted to the change of pages in the database and no more based on the time (RTO vs RPO).
\nLet\u2019s go to the new DMV sys.dm_db_log_stats do to the same with the TLog backup.<\/p>\n
DMV sys.dm_db_log_stats<\/h3>\n
This DMV gives really good information about the transaction log files and can help to adapt the backup strategy and also control the growth of the file.
\nThe DMV is very easy to use and for example, if you want to have the growth of the size since the last TLog backup, use the column log_since_last_log_backup_mb<\/p>\n
SELECT log_since_last_log_backup_mb from sys.dm_db_log_stats(DB_ID('smart_backup_2016'))\nGO<\/pre>\n
\"smart_backup05\"<\/a>
\nLike below, I create in our DMK maintenance an adapted TLOG Backup [dbi_smart_tlog_backup]
\n\"smart_backup06\"<\/a>
\nIf the TLOG is growing more that 5 MB from the last TLOG backup, It will do a TLOG Backup and if not, no TLOG Backup.
\nIn my example, the growth is 548 MB, then a TLOG Backup is necessary.
\n\"smart_backup07\"<\/a>
\nAfter, I control the size and as you can see the size since last TLOG Backup is 0.07MB
\n\"smart_backup08\"<\/a>
\nAs you can see, no TLOG backup\u2026 My backup strategy is adapted to the load! \ud83d\ude09
\n\"smart_backup09\"<\/a><\/p>\n
DMV sys.dm_db_log_info<\/h3>\n
This DMV will help us to have all VLF(Virtual Log File) information and no more using the DBCC Loginfo.
\nYou can use this DMV very easily like this:<\/p>\n
SELECT [name] AS 'Database Name', COUNT(l.database_id) AS 'VLF Count'\nFROM sys.databases s\nCROSS APPLY sys.dm_db_log_info(s.database_id) l\nGROUP BY [name]\n<\/pre>\n
\"smart_backup10\"<\/a><\/p>\n
These DMVs are very helpful and it is a good thing to have it also in SQL Server 2016 now.<\/p>\n","protected":false},"excerpt":{"rendered":"
Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016 was released and distributed. This Service Pack has new DMVs, already available in SQL Server 2017 RTM. In this article, I will just write few words about 2 DMVs (sys.dm_db_log_stats & sys.dm_db_log_info) and a new column (modified_extent_page_count) in the DMV sys.dm_db_file_space_usage that […]<\/p>\n","protected":false},"author":15,"featured_media":11248,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368,99,48],"tags":[202,49,51,566],"type_dbi":[],"class_list":["post-11238","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-development-performance","category-sql-server","category-technology-survey","tag-backup","tag-microsoft","tag-sql-server","tag-sql-server-2016"],"acf":[],"yoast_head":"\nSP2 for SQL Server 2016 is available with new helpful 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\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SP2 for SQL Server 2016 is available with new helpful DMVs\" \/>\n<meta property=\"og:description\" content=\"Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016 was released and distributed. This Service Pack has new DMVs, already available in SQL Server 2017 RTM. In this article, I will just write few words about 2 DMVs (sys.dm_db_log_stats & sys.dm_db_log_info) and a new column (modified_extent_page_count) in the DMV sys.dm_db_file_space_usage that […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-11T12:23:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"523\" \/>\n\t<meta property=\"og:image:height\" content=\"378\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"5 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\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SP2 for SQL Server 2016 is available with new helpful DMVs\",\"datePublished\":\"2018-05-11T12:23:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\"},\"wordCount\":551,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg\",\"keywords\":[\"Backup\",\"Microsoft\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Development & Performance\",\"SQL Server\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\",\"name\":\"SP2 for SQL Server 2016 is available with new helpful DMVs - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg\",\"datePublished\":\"2018-05-11T12:23:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg\",\"width\":523,\"height\":378},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SP2 for SQL Server 2016 is available with new helpful 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 & 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":"SP2 for SQL Server 2016 is available with new helpful 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\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/","og_locale":"en_US","og_type":"article","og_title":"SP2 for SQL Server 2016 is available with new helpful DMVs","og_description":"Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016 was released and distributed. This Service Pack has new DMVs, already available in SQL Server 2017 RTM. In this article, I will just write few words about 2 DMVs (sys.dm_db_log_stats & sys.dm_db_log_info) and a new column (modified_extent_page_count) in the DMV sys.dm_db_file_space_usage that […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/","og_site_name":"dbi Blog","article_published_time":"2018-05-11T12:23:13+00:00","og_image":[{"width":523,"height":378,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SP2 for SQL Server 2016 is available with new helpful DMVs","datePublished":"2018-05-11T12:23:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/"},"wordCount":551,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg","keywords":["Backup","Microsoft","SQL Server","SQL Server 2016"],"articleSection":["Database Administration & Monitoring","Development & Performance","SQL Server","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/","url":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/","name":"SP2 for SQL Server 2016 is available with new helpful DMVs - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg","datePublished":"2018-05-11T12:23:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/smart_backup10.jpg","width":523,"height":378},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sp2-for-sql-server-2016-is-available-with-new-helpful-dmvs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SP2 for SQL Server 2016 is available with new helpful 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 & 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\/11238","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=11238"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11238\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11248"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11238"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}