sql server, disk space, shrink, cpu - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Browse by Tags

Does DBCC SHRINKFILE consumes operating system resources such as memory, CPU usage etc.? Published 25 July 7 4:30 AM | SSQA.net: Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to the server. But think about performing the SHRINK operation of transaction log & database files on regular basis, say within a scheduled job or ongoing...

Filed under: sql server, memory, database, shrink, disk space, cpu