SQL Server Performance

Does DBCC SHRINKFILE consumes operating system resources such as memory, CPU usage etc.?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 25, 2007.

  1. Anonymous New Member

    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 &amp; database files on regular basis, say within a scheduled job or ongoing process. Further to my tests refer to this SSPFAQ post for further information in performing the shrink operation within your SQL Server enviornment....(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/07/25/does-dbcc-shrinkfile-consumes-operating-system-resources-such-as-memory-cpu-usage-etc.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1153" width="1" height="1">

Share This Page