contig issue with sql server on VM box

  • 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