Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup Shrink Logs
Message
From
29/01/2013 08:59:42
 
 
To
29/01/2013 06:08:28
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01564409
Message ID:
01564488
Views:
33
>Here's one of the articles: http://www.sqlservercentral.com/articles/SHRINKFILE/71414/ not sure if you need to join to read it, but joining is free.
>
>A quote from the article:
>
>"In the SHRINKFILE command, SQL Server isn't especially careful about where it puts the pages being moved from the end of the file to open pages towards the beginning of the file. This causes two problems:
>
>the data becomes fragmented, potentially up to 100% fragmentation, this is a performance killer for your database;
>the operation is slow - all pointers to / from the page / rows being moved have to be fixed up, and the SHRINKFILE operation is single-threaded, so it can be really slow (the single-threaded nature of SHRINKFILE is not going to change any time soon)."

Yes, I was aware of that reading but this was never observed on this side.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform