May 30, 2018 at 12:01 pm
Is there any harm by using windows compression on the directory where the data files or log files are
May 30, 2018 at 12:16 pm
Not for data, that should be OK.
I'd say do not compress log files using Windows or anything external to SQL Server.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 1, 2018 at 10:28 am
keanyukas - Wednesday, May 30, 2018 12:01 PMIs there any harm by using windows compression on the directory where the data files or log files are
I would not put data and log on compressed folder, you wouldn't be able to install SQL binaries on compressed folder. If you ever run in perf issues will be very hard to pin point if compression at drive level is causing issue. Btw why do you want to put it on a compressed folder?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply