SQL

A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI / ISO standard.

Write an Article

Join

RSS

SQL SERVER - DBCC SHRINKFILE Takes Long Time to Run

Written by pinaldave on

From: blog.sqlauthority.com

If you are DBA who are involved with Database Maintenance and file group maintenance, you must have experience that many times DBCC SHRINKFILE operations takes long time but any other operations with Database are relative quicker. Rebuilding index is quite resource intensive task but that happens faster than DBCC SHRINGFILE.

Well, answer to this is very simple. DBCC SHRINKFILE is a single threaded operation. A single threaded operation does not take advantage of multiple CPUs and have no effect how many RAM are available. Hyperthreaded CPU even provides worst performance.

If you rebuild indexes before you run DBCC SHRINKFILE operations, shrinking file operations will take relatively less time. Rebuilding Index operations takes advantage of multiple CPUs.

Reference : Pinal Dave (http://www.SQLAuthority.com)

	Camera Buying Tips A picture is worth a thousand words, but not all cameras are worth a thousand bucks.
	10 Places to Get FREE Images for your Blog Gotta love the word "Free".
	Astronomy Picture Of The Day This picture makes us feel very very small.