September 23, 2024 at 11:00 am
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 ,
I want to know if Write operation also have same Pros and Cons in terms of CPU , time Etc.
September 24, 2024 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 25, 2024 at 8:19 am
"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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy