compress drive | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

compress drive

IF I select ‘Compress’ option for the drive on which transacion logs are kept, whether it will have the impact on the database performance ?
Yes, it will increase latency of log I/O operations and also CPU load will increase (I do not know by how much).
I would not recommend this.
Storing data files or log files on a compressed drive or file can prevent database recovery. Never store data on drives or in directories with compression enabled. If you want to track the size of transaction log file and shrink it periodically then refer to this link and schedule DBCC SHRINKFILE to shrink the Tlog file. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.