T
Tom Ellison
WinXP Pro
I suspected my database (Access MDB) was not operating anywhere close to
optimally, probably due to fragmentation.
Using the defragmenter, I defragged the drive.
When defragmenter finishes it shows 6 large and very fragmented files in a
list "Files that did not defragment:"
The one file I wanted defragmented is in this list. Statistics are:
Fragments: 11,045
File Size: 1.88 GB
All the files that did not defrag are 1.5 - 3 GB and are horribly
fragmented, with 3000 to 15000 fragments.
There is 7.6 GB free space, much larger than any of these files.
Repeated defragmenting does no more to remedy this.
Do I need more free space before I can defrag these?
I have shut down SQL Server Services, which might otherwise have been
accessing these files. Can I also check for other possble causes why they
may be open? Computer Management/System Tools/Shared Folders/Open Files
shows no files open. This is only for sharing, right? Where could I look
for locally opened files?
Thanks!
Tom Ellison
I suspected my database (Access MDB) was not operating anywhere close to
optimally, probably due to fragmentation.
Using the defragmenter, I defragged the drive.
When defragmenter finishes it shows 6 large and very fragmented files in a
list "Files that did not defragment:"
The one file I wanted defragmented is in this list. Statistics are:
Fragments: 11,045
File Size: 1.88 GB
All the files that did not defrag are 1.5 - 3 GB and are horribly
fragmented, with 3000 to 15000 fragments.
There is 7.6 GB free space, much larger than any of these files.
Repeated defragmenting does no more to remedy this.
Do I need more free space before I can defrag these?
I have shut down SQL Server Services, which might otherwise have been
accessing these files. Can I also check for other possble causes why they
may be open? Computer Management/System Tools/Shared Folders/Open Files
shows no files open. This is only for sharing, right? Where could I look
for locally opened files?
Thanks!
Tom Ellison