Perfromance Impact Benchmark of Data Compression on write operation

• IT researcher

  SSCertifiable

  Points: 7600

  More actions

  September 23, 2024 at 11:00 am

  #4461495

  I would like to get the benchmark test case results of Write operations (insert , update) after Page/Row Data Compression enabled in SQL Server Database.

  Here I have found some Results of Read operation ,

  https://www.mssqltips.com/sqlservertip/3187/demonstrating-the-effects-of-using-data-compression-in-sql-server/

  I want to know if Write operation also have same Pros and Cons in terms of CPU , time Etc.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 24, 2024 at 11:10 am

  #4461833

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  September 24, 2024 at 8:44 pm

  #4461994

  IT researcher wrote:

  I want to know if Write operation also have same Pros and Cons in terms of CPU , time Etc.

  What results did your research produce?

• MMartin1

  One Orange Chip

  Points: 27795

  More actions

  September 25, 2024 at 8:19 am

  #4462130

  "Avoid using Encrypting File System (EFS) and file-system compression because they cause asynchronous I/O to become synchronous and therefore slower. For more information, see the Asynchronous disk I/O appears as synchronous on Windows article."  https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-sql-io-performance#causes

  Common sense tells me encryption/decryption will use more cpu cycles. Exactly how much is something you can explore and post back on.

   

  ----------------------------------------------------

• September 25, 2024 at 9:57 am

  This was removed by the editor as SPAM

• September 25, 2024 at 1:11 pm

  This was removed by the editor as SPAM