{"id":29285,"date":"2023-11-16T08:30:56","date_gmt":"2023-11-16T07:30:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=29285"},"modified":"2023-11-16T12:46:29","modified_gmt":"2023-11-16T11:46:29","slug":"sql-server-integrated-acceleration-offloading","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/","title":{"rendered":"SQL Server Integrated acceleration &amp; offloading"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-introduction\">Introduction<\/h2>\n\n\n\n<p>I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration &amp; offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to hardware devices.<\/p>\n\n\n\n<p>&nbsp;At first it seems very interresting to speed up for instance backup tasks especially for big databases.<\/p>\n\n\n\n<p>But reading the documentation, specifically the Intel drivers information, I was disappointed, because it was specified that the CPU must support the QuickAssist Technology (IntelQAT) and for virtualized Windows Server only Hyper-V was supported.<\/p>\n\n\n\n<p>My customer environment was not at all in this situation, running the SQL Server on VMWare and the host having CPU without this QAT feature available.<\/p>\n\n\n\n<p>I thought than that it was not possible to use this new feature, but my customer found some blog explaining that the CPU must not specifically have this QAT feature. The acceleration can be done only on software level and not hardware.<\/p>\n\n\n\n<p>Well I was curious than to test this solution and see if it really can save time for the backup tasks.<\/p>\n\n\n\n<p>Let\u2019s have a look first, what we need to install, how to install the needed drivers and how to &nbsp;configure SQL Server to be able to use this &nbsp;Integrated acceleration &amp; offloading feature.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-installation-of-the-latest-intelqat-driver-nbsp\"><strong>Installation of the latest IntelQAT driver<\/strong>&nbsp;<\/h2>\n\n\n\n<p>You wiil be able to find and download the latest IntelQAT driver from\u00a0 the following link:<\/p>\n\n\n\n<p><a href=\"https:\/\/www.intel.com\/content\/www\/us\/en\/download\/765502\/intel-quickassist-technology-driver-for-windows-hw-version-2-0.html\" target=\"_blank\" rel=\"noreferrer noopener\">Intel\u00ae QuickAssist Technology Driver for Windows* \u2013 HW Version 2.0<\/a><\/p>\n\n\n\n<p>Save the IntelQAT drvier in c:\\temp and unzip the QAT2.0.W.2.0.5-0014.zip file in C:\\temp\\IntelQAT\\QAT2.0.W.2.0.5-0014 folder<\/p>\n\n\n\n<p>To install the IntelQAT driver start the QatSetup.exe located in C:\\temp\\IntelQAT\\QAT2.0.W.2.0.5-0014\\QuickAssist\\Setup&nbsp;<\/p>\n\n\n\n<p>Click\u00a0[yes]\u00a0to the warning, to use the software compression option. You can see that in this version it is only a warning asking if you want to use software compression because the QuickAssist Technology Accelerator option is not available on processor hardware on the system. In older driver installation wizard it was an error message, that was a bit scaring, but the warning message reassure me that it can be used even if the Host CPU have no QAT possibility.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"378\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png\" alt=\"\" class=\"wp-image-29378\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png 498w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01-300x228.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/figure>\n\n\n\n<p>For the driver installation, that is all what need to be done. Very easy in fact.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Configuration of the SQL Server instance<\/h1>\n\n\n\n<p>In order to configure the SQL Server instance I did the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enable hardware offloading, setting the server configuration option<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nexecute sp_configure &#039;show advanced options&#039;, 1\nRECONFIGURE\nexecute sp_configure &#039;hardware offload enabled&#039;, 1\nRECONFIGURE\nGO\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Restart the SQL Server service (in case of AlwaysOn setup, if your server is primary, failover the availability group to the other replica){<\/strong>}<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enable accelerator hardware offloading<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SERVER CONFIGURATION&amp;nbsp;&amp;nbsp;\nSET HARDWARE_OFFLOAD = ON (ACCELERATOR = QAT);\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Restart the SQL Server service<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Check if you configuration is set&nbsp; correctly<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Run first the following query<\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect *\nfrom sys.configurations c\nwhere c.name like &#039;backup compression%&#039;\nor c.name like &#039;%offload%&#039;\norder by c.name\n<\/pre><\/div>\n\n\n<p>Check that the values of the SQL Server instance configuration parameter<br>hardware offload enabled = 1<\/p>\n\n\n\n<p>Check if the IntelQAT driver is detected<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect * from sys.dm_server_accelerator_status\n<\/pre><\/div>\n\n\n<p>Check if you have the QAT accelarator&nbsp;[mode_reason_desc]&nbsp;has the value &#8216;SOFTWARE_MODE_ACCELERATOR_HARDWARE_NOT_FOUND&#8217;<br>Check also the&nbsp;[accelerator_library_version]&nbsp;column to check the version of the driver detected.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"37\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_02.png\" alt=\"\" class=\"wp-image-29379\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_02.png 605w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_02-300x18.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-test-the-backup\">Test the backup<\/h2>\n\n\n\n<p><strong>With normal compression algorithm = MS_XPRESS<\/strong>&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBACKUP DATABASE &#x5B;TestDB] TO DISK = N&#039;\\\\BackupShareDrive\\TestDB_FULLbackup_CopyOnly_20231102_MS_XPRESS.bak&#039; \nWITH CHECKSUM, COMPRESSION, COPY_ONLY\n\nProcessed 15956856 pages for database &#039;TestDB&#039;, file &#039;TestDB&#039; on file 1.\nProcessed 5 pages for database &#039;TestDB&#039;, file &#039;TestDB_log&#039; on file 1.\nBACKUP DATABASE successfully processed 15956861 pages in 499.640 seconds (249.505 MB\/sec).\n\nCompletion time: 2023-11-02T15:33:54.1892323+01:00\n\n\n<\/pre><\/div>\n\n\n<p><strong>With IntelQAT compression algorithm = QAT_DEFLATE<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBACKUP DATABASE &#x5B;TestDB] TO DISK = N&#039;\\\\BackupShareDrive\\TestDB_FULLbackup_CopyOnly_20231102_QAT_DEFLATE.bak&#039; \nWITH CHECKSUM, COMPRESSION (ALGORITHM = QAT_DEFLATE), COPY_ONLY,  STATS = 10 \n\n\nProcessed 15956704 pages for database &#039;TestDB&#039;, file &#039;TestDB&#039; on file 1.\nProcessed 1 pages for database &#039;TestDB&#039;, file &#039;TestDB_log&#039; on file 1.\nBACKUP DATABASE successfully processed 15956705 pages in 238.594 seconds (522.484 MB\/sec).\n\nCompletion time: 2023-11-02T15:40:47.8642423+01:00\n\n<\/pre><\/div>\n\n\n<p>We can notice that the backup time was reduce by 2<\/p>\n\n\n\n<p><strong>Check the backup information<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect\nbs.database_name,\nbs.backup_start_date,\nbs.backup_finish_date,\n1.0 * datediff(second,bs.backup_start_date,bs.backup_finish_date)\/60 as BackupDuration_Min,\nbs.backup_finish_date,\nbs.backup_size,\nbs.compressed_backup_size,\nbs.compression_algorithm\n\nfrom msdb.dbo.backupset bs\nwhere bs.database_name = &#039;TestDB&#039;\n\n\n<\/pre><\/div>\n\n\n<p>Configure the backup to have the IntelQAT software compression with algorithm = QAT_DEFLATE by default.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nexecute sp_configure &#039;backup compression algorithm&#039;, 2\nRECONFIGURE\n\n<\/pre><\/div>\n\n\n<p>If you start now a database backup the QAT_DEFLATE compression algorithm will be apply by default. You do not have to specify it specifically on your backup command.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>The feature is quite easy to configure. It can speed up your big database backups with very few configuration effort.<\/p>\n\n\n\n<p>It is a mean to save time and disk space too, although the compression ratio is not really higher than the standard compression mode.  <\/p>\n\n\n\n<p>It is just annoying that the Intel QAT driver documentation specify that only processors with the QAT feature and Hyper-V virtualization is supported by this driver&#8230;but it seems to work well using the software only option.<\/p>\n\n\n\n<p>But before deciding to go for it, of course,  I do not have to tell you, please test the restore process&#8230;<\/p>\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration &amp; offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to hardware devices. &nbsp;At first it seems very interresting to speed up for instance backup tasks [&hellip;]<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[202,1461,3171],"type_dbi":[2874],"class_list":["post-29285","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","tag-backup","tag-compression","tag-qat","type-sql-server"],"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 Integrated acceleration &amp; offloading - 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-integrated-acceleration-offloading\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Integrated acceleration &amp; offloading\" \/>\n<meta property=\"og:description\" content=\"Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration &amp; offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to hardware devices. &nbsp;At first it seems very interresting to speed up for instance backup tasks [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-16T07:30:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-16T11:46:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png\" \/>\n<meta name=\"author\" content=\"Christophe Cosme\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christophe Cosme\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-integrated-acceleration-offloading\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/\"},\"author\":{\"name\":\"Christophe Cosme\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5cbf7c261d165a45977c85f535d6cb6a\"},\"headline\":\"SQL Server Integrated acceleration &amp; offloading\",\"datePublished\":\"2023-11-16T07:30:56+00:00\",\"dateModified\":\"2023-11-16T11:46:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/\"},\"wordCount\":704,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/11\\\/chc_blog20231113_01.png\",\"keywords\":[\"Backup\",\"compression\",\"QAT\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/\",\"name\":\"SQL Server Integrated acceleration &amp; offloading - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/11\\\/chc_blog20231113_01.png\",\"datePublished\":\"2023-11-16T07:30:56+00:00\",\"dateModified\":\"2023-11-16T11:46:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5cbf7c261d165a45977c85f535d6cb6a\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/11\\\/chc_blog20231113_01.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/11\\\/chc_blog20231113_01.png\",\"width\":498,\"height\":378},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-integrated-acceleration-offloading\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Integrated acceleration &amp; offloading\"}]},{\"@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\\\/5cbf7c261d165a45977c85f535d6cb6a\",\"name\":\"Christophe Cosme\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"caption\":\"Christophe Cosme\"},\"description\":\"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/christophe-cosme\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Integrated acceleration &amp; offloading - 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-integrated-acceleration-offloading\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Integrated acceleration &amp; offloading","og_description":"Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration &amp; offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to hardware devices. &nbsp;At first it seems very interresting to speed up for instance backup tasks [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/","og_site_name":"dbi Blog","article_published_time":"2023-11-16T07:30:56+00:00","article_modified_time":"2023-11-16T11:46:29+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png","type":"","width":"","height":""}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christophe Cosme","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/"},"author":{"name":"Christophe Cosme","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"headline":"SQL Server Integrated acceleration &amp; offloading","datePublished":"2023-11-16T07:30:56+00:00","dateModified":"2023-11-16T11:46:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/"},"wordCount":704,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png","keywords":["Backup","compression","QAT"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/","name":"SQL Server Integrated acceleration &amp; offloading - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png","datePublished":"2023-11-16T07:30:56+00:00","dateModified":"2023-11-16T11:46:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/chc_blog20231113_01.png","width":498,"height":378},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-integrated-acceleration-offloading\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Integrated acceleration &amp; offloading"}]},{"@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\/5cbf7c261d165a45977c85f535d6cb6a","name":"Christophe Cosme","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","caption":"Christophe Cosme"},"description":"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.","url":"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/29285","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\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=29285"}],"version-history":[{"count":12,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/29285\/revisions"}],"predecessor-version":[{"id":29397,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/29285\/revisions\/29397"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=29285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=29285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=29285"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=29285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}