Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
winanjaya
Starting Member
3 Posts |
 Posted - 2008-12-09 : 21:12:43
|
| Dear All,My database size is 14GB, please help why SQL server 2005 takes never ending process when shrinking my database? what I missed? ..Please helpThanks & RegardsWinanjaya |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 22:32:38
|
| Because due to the fact that Shrink occurs with Single-Threaded operation and doesn't take advantages of multiple CPU's. 14GB is not big enough to shrink.You will get performance issue with it. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-12-10 : 02:28:51
|
| Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down as the file is expanded. Also repeated shrinks and grows will cause fragmentation at the file-system level, which is hard to fix.See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database shrinking