Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is “NTFS Data File Encryption and Compression” Turned Off?

April 26, 2017compression Data database database management encryption file MySQL NTFS sql turned

0

Posted

Is “NTFS Data File Encryption and Compression” Turned Off?

1 Answer

0

Posted

NTFS 5.0 under Windows 2000 supports both file encryption and compression, and by default, these two features are turned off on a newly installed Windows 2000 or 2003 server. While these features do provide some benefits under limited circumstances, they do not provide any benefits for SQL Server. In fact, using one or both of these features can greatly hurt performance. As you know, SQL Server is very I/O intensive, and anything that increases disk I/O hurts SQL Server’s performance. Both file encryption and compressions significantly increase disk I/O as data files have to be manipulated on the fly as they are used. So if either file encryption or compression is used on SQL Server files, performance will greatly suffer. If you become the DBA of a currently existing SQL Server, and are not familiar with it, check to see if anyone mistakenly have turned on either of these functions. If so, and you turn them off, you will become a performance hero to all of the server’s users. Does Your