November 5, 2014 at 7:14 am
Hello, experts.
I ran contig.exe 1.7 with -a on the mdf file of a 91 GB database on a sql server 2012 server running on a VM box, and it said there were 109 fragments.
I then brought the database offline, and ran contig without the -a, and it said No files fragmented.
After I brought the database online, contig -a again said there were 109 fragments.
I even tried running contig with the sql server stopped, but it still found no fragmentation.
Has anyone run into similar issues?
I'd really appreciate if anyone has any suggestions on any parameter or option I need to use to get rid of the fragmentation.
Here's the actual output, with the database name replaced by xxx, in case that helps. Thanks.
C:\downloads>contig.exe -a E:\data\xxx.mdf
Contig v1.7 - Makes files contiguous
Copyright (C) 1998-2012 Mark Russinovich
Sysinternals - http://www.sysinternals.com
E:\data\xxx.mdf is in 109 fragments
Summary:
Number of files processed : 1
Average fragmentation : 109 frags/file
C:\downloads>contig.exe E:\data\xxxOuch.mdf
Contig v1.7 - Makes files contiguous
Copyright (C) 1998-2012 Mark Russinovich
Sysinternals - http://www.sysinternals.com
Processing E:\data\xxx.mdf...
Scanning Disk: 0xc0000022
No files fragmented.
C:\downloads>contig.exe -a E:\data\xxx.mdf
Contig v1.7 - Makes files contiguous
Copyright (C) 1998-2012 Mark Russinovich
Sysinternals - http://www.sysinternals.com
E:\data\xxx.mdf is in 109 fragments
Summary:
Number of files processed : 1
Average fragmentation : 109 frags/file
C:\downloads>
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply