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

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">