Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Physical SQL file defrag - needed?
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Physical SQL file defrag - needed?
Miscellaneous
Thread ID:
00698307
Message ID:
00698307
Views:
63
For various reasons, the files of a SQL database have to be defragmented. I am referring to the physical file fragmentation (not internal data/page fragmentation of a database/table) on disk.

Defragmentation utilities, like DiskKeeper, can do the job, but require that SQL server be shut down during defragmentation. As this is not possible in most cases, how is defragmentation accomplished in 24x7 operations? Is it necessary? Does anyone have any experience with this issue?

This is a question I asked about a year ago. I was wondering if any new advances or changes have been reported in this issue. I came across this article: http://www.dmreview.com/editorial/dmdirect/dmdirect_article.cfm?EdID=5658&issue=082302&record=3 which mentions that one should definitely defragment frequently.

Thank you,
Aristotle
Next
Reply
Map
View

Click here to load this message in the networking platform