SQL Server Performance Forum – Threads Archive
compress driveIF 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 linkhttp://vyaskn.tripod.com/track_sql_database_file_growth.htm 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.