Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
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 & 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.

Posted: Wednesday, July 25, 2007 2:30 AM by SQL Master

Comments

SSQA.net - SqlServer-QA.net said:

Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to

# July 25, 2007 4:19 AM

Other SQL Server Blogs around the Web said:

Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to

# August 14, 2007 8:00 AM
Anonymous comments are disabled