Forum Discussion

John_Santana's avatar
John_Santana
Level 6
11 years ago

Enterprise Vault maintenance on SQL Server which cause outage ?

Hi People,

How often does the EV server needs to be taken offline or all of the services is stopped so that the SQL Server maintenance can be performed based on the following Technote article:

http://www.symantec.com/business/support/index?page=content&id=TECH74591
http://www.symantec.com/business/support/index?page=content&id=TECH74666

I wonder as to why do I need to bring the EV server down first ?

Can this be done during the EV backup mode ? because my EV backup window for the Open Index and VaultStore partition takes about one week to finish.

Best Practice
Enterprise Vault
Information Governance
Tip-How to
Windows Server (2003-2008)
  • Arjun_Shelke's avatar
    Arjun_Shelke
    11 years ago

    If you keep the EV services running, there are chances that SQL Database table indexes might not rebuild. Because services may lock some of the table indexes. In that case, running maintenance to reduce the fragmentations will not give you better results.

  • Trafford's avatar
    Trafford
    11 years ago

    Hi John,

    Getting that SQL maintenance right will definitely help. I have seen dramatic improvements in archive rate after an SQL clean up. EV is hugely dependent on SQL, if your SQL is not flying, neither will EV. follow the recommendations in tech74666, or even get a professional DBA to assist, it is well worth the effort.

    Use the SQL PActivity Monitor to see how it is doing.

    http://msdn.microsoft.com/en-us/library/cc879320.aspx

     

  • AndrewB's avatar
    AndrewB
    11 years ago

    Hi John,

    Here are two very well-known sources that should help.

    http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

    http://sqlfool.com/2011/06/index-defrag-script-v4-1/

13 Replies

Sort By
  • Arjun_Shelke's avatar
    Arjun_Shelke
    Level 6
    11 years ago

    If you keep the EV services running, there are chances that SQL Database table indexes might not rebuild. Because services may lock some of the table indexes. In that case, running maintenance to reduce the fragmentations will not give you better results.

  • Arjun_Shelke's avatar
    Arjun_Shelke
    Level 6
    11 years ago

    Using EV backup mode, we can restrict most of the EV operations (write operations). The backup mode reduces the number calls to SQL server because less operations allowed, however EV still allows users to retrieve the archived data. So that said, using backup mode, we are not stopping all processes which are using SQL Databases. Hence backup mode may help you to a certain extent in SQL maintenance, but not the best option.

    Many a times, with backup mode, you will need to re-run the maintenance multiple times in order to get fragmentations in control.

  • John_Santana's avatar
    John_Santana
    Level 6
    11 years ago

    ok, so even with the setting it as backup mode will not help me to achieve the full SQL database maintenance ?

    Because at the moment I feel that my EV archiving is running slow at about 1 message per seconds with the back log of more than 200.000 emails in the EV journal continuously flowing from the Exchange Server journal mailbox and other mailboxes.

  • Arjun_Shelke's avatar
    Arjun_Shelke
    Level 6
    11 years ago

    Well as I said, the EV Backup mode will help you to certain extent considering the low fragmentation. I would suggest, running the DBCC showcontig commands to know the fragmentation levels within Directory and Vault Store databases. If fragmentations are high then stopping EV services while performing the maintenance is the best way forward.

  • Trafford's avatar
    Trafford
    Level 4
    11 years ago

    Hi John,

    Getting that SQL maintenance right will definitely help. I have seen dramatic improvements in archive rate after an SQL clean up. EV is hugely dependent on SQL, if your SQL is not flying, neither will EV. follow the recommendations in tech74666, or even get a professional DBA to assist, it is well worth the effort.

    Use the SQL PActivity Monitor to see how it is doing.

    http://msdn.microsoft.com/en-us/library/cc879320.aspx

     

  • John_Santana's avatar
    John_Santana
    Level 6
    11 years ago

    Hi Advisor, thanks for the clarification.

    Which database should be the best indicator that my SQL Server is heavily fragmented ?

    EnterpriseVaultDirectory
    EVVaultstore1

    or both ?

  • Arjun_Shelke's avatar
    Arjun_Shelke
    Level 6
    11 years ago

    I would say both, but generally archiving process mostly depends upon the fragmentations of saveset, sispart, journalarchive, watchfile tables. And these tables are fragmented frequently because of addition/deletion rate.

    So Vault Store database should be the best indicator for you in such instance.

  • John_Santana's avatar
    John_Santana
    Level 6
    11 years ago

    Upon executing the command: DBCC SHOWCONTIG WITH ALL_INDEXES it took around 8 minutes, is that considered as normal ?

    DBCC SHOWCONTIG scanning 'HoldGroup' table...

Table: 'HoldGroup' (5575058); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldGroup' table...

Table: 'HoldGroup' (5575058); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldGroup' table...

Table: 'HoldGroup' (5575058); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldSaveset' table...

Table: 'HoldSaveset' (21575115); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldSaveset' table...

Table: 'HoldSaveset' (21575115); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldSaveset' table...

Table: 'HoldSaveset' (21575115); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldSaveset' table...

Table: 'HoldSaveset' (21575115); index ID: 6, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldSaveset' table...

Table: 'HoldSaveset' (21575115); index ID: 8, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'JournalArchive' table...

Table: 'JournalArchive' (37575172); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 68770

- Extents Scanned..............................: 8633

- Extent Switches..............................: 8910

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 96.48% [8597:8911]

- Logical Scan Fragmentation ..................: 5.68%

- Extent Scan Fragmentation ...................: 64.35%

- Avg. Bytes Free per Page.....................: 455.2

- Avg. Page Density (full).....................: 94.38%

DBCC SHOWCONTIG scanning 'JournalArchive' table...

Table: 'JournalArchive' (37575172); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 6066

- Extents Scanned..............................: 759

- Extent Switches..............................: 758

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [759:759]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 60.21%

- Avg. Bytes Free per Page.....................: 11.1

- Avg. Page Density (full).....................: 99.86%

DBCC SHOWCONTIG scanning 'JournalArchive' table...

Table: 'JournalArchive' (37575172); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 4333

- Extents Scanned..............................: 542

- Extent Switches..............................: 541

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [542:542]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 47.97%

- Avg. Bytes Free per Page.....................: 11.4

- Avg. Page Density (full).....................: 99.86%

DBCC SHOWCONTIG scanning 'JournalArchive' table...

Table: 'JournalArchive' (37575172); index ID: 4, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 4616

- Extents Scanned..............................: 577

- Extent Switches..............................: 576

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [577:577]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 62.91%

- Avg. Bytes Free per Page.....................: 1.1

- Avg. Page Density (full).....................: 99.99%

DBCC SHOWCONTIG scanning 'JournalArchive' table...

Table: 'JournalArchive' (37575172); index ID: 5, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 3861

- Extents Scanned..............................: 491

- Extent Switches..............................: 519

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 92.88% [483:520]

- Logical Scan Fragmentation ..................: 6.19%

- Extent Scan Fragmentation ...................: 69.45%

- Avg. Bytes Free per Page.....................: 232.8

- Avg. Page Density (full).....................: 97.12%

DBCC SHOWCONTIG scanning 'JournalArchive' table...

Table: 'JournalArchive' (37575172); index ID: 6, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 14653

- Extents Scanned..............................: 1840

- Extent Switches..............................: 5419

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 33.80% [1832:5420]

- Logical Scan Fragmentation ..................: 27.63%

- Extent Scan Fragmentation ...................: 67.50%

- Avg. Bytes Free per Page.....................: 3792.8

- Avg. Page Density (full).....................: 53.14%

DBCC SHOWCONTIG scanning 'JournalDelete' table...

Table: 'JournalDelete' (53575229); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 2345

- Extents Scanned..............................: 294

- Extent Switches..............................: 293

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [294:294]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 33.33%

- Avg. Bytes Free per Page.....................: 142.5

- Avg. Page Density (full).....................: 98.24%

DBCC SHOWCONTIG scanning 'JournalDelete' table...

Table: 'JournalDelete' (53575229); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 853

- Extents Scanned..............................: 107

- Extent Switches..............................: 106

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [107:107]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 54.21%

- Avg. Bytes Free per Page.....................: 48.1

- Avg. Page Density (full).....................: 99.41%

DBCC SHOWCONTIG scanning 'JournalDelete' table...

Table: 'JournalDelete' (53575229); index ID: 4, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 1088

- Extents Scanned..............................: 136

- Extent Switches..............................: 135

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [136:136]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 45.59%

- Avg. Bytes Free per Page.....................: 2025.3

- Avg. Page Density (full).....................: 74.98%

DBCC SHOWCONTIG scanning 'JournalDelete' table...

Table: 'JournalDelete' (53575229); index ID: 5, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 906

- Extents Scanned..............................: 114

- Extent Switches..............................: 113

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 100.00% [114:114]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 44.74%

- Avg. Bytes Free per Page.....................: 40.6

- Avg. Page Density (full).....................: 99.50%

DBCC SHOWCONTIG scanning 'JournalDelete' table...

Table: 'JournalDelete' (53575229); index ID: 10, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 2729

- Extents Scanned..............................: 342

- Extent Switches..............................: 341

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [342:342]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 52.05%

- Avg. Bytes Free per Page.....................: 3960.9

- Avg. Page Density (full).....................: 51.06%

DBCC SHOWCONTIG scanning 'JournalDelete' table...

Table: 'JournalDelete' (53575229); index ID: 13, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 971

- Extents Scanned..............................: 131

- Extent Switches..............................: 142

- Avg. Pages per Extent........................: 7.4

- Scan Density [Best Count:Actual Count].......: 85.31% [122:143]

- Logical Scan Fragmentation ..................: 5.36%

- Extent Scan Fragmentation ...................: 99.24%

- Avg. Bytes Free per Page.....................: 133.5

- Avg. Page Density (full).....................: 98.35%

DBCC SHOWCONTIG scanning 'JournalRestore' table...

Table: 'JournalRestore' (69575286); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 7921.0

- Avg. Page Density (full).....................: 2.14%

DBCC SHOWCONTIG scanning 'Saveset' table...

Table: 'Saveset' (117575457); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 587378

- Extents Scanned..............................: 73526

- Extent Switches..............................: 104347

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 70.36% [73423:104348]

- Logical Scan Fragmentation ..................: 11.21%

- Extent Scan Fragmentation ...................: 20.75%

- Avg. Bytes Free per Page.....................: 67.4

- Avg. Page Density (full).....................: 99.17%

DBCC SHOWCONTIG scanning 'Saveset' table...

Table: 'Saveset' (117575457); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 110017

- Extents Scanned..............................: 13774

- Extent Switches..............................: 13798

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 99.67% [13753:13799]

- Logical Scan Fragmentation ..................: 0.25%

- Extent Scan Fragmentation ...................: 22.53%

- Avg. Bytes Free per Page.....................: 58.9

- Avg. Page Density (full).....................: 99.27%

DBCC SHOWCONTIG scanning 'Saveset' table...

Table: 'Saveset' (117575457); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 197151

- Extents Scanned..............................: 24644

- Extent Switches..............................: 24643

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [24644:24644]

- Logical Scan Fragmentation ..................: 0.07%

- Extent Scan Fragmentation ...................: 22.71%

- Avg. Bytes Free per Page.....................: 23.0

- Avg. Page Density (full).....................: 99.72%

DBCC SHOWCONTIG scanning 'Saveset' table...

Table: 'Saveset' (117575457); index ID: 4, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 138376

- Extents Scanned..............................: 17297

- Extent Switches..............................: 17296

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [17297:17297]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 43.17%

- Avg. Bytes Free per Page.....................: 2.0

- Avg. Page Density (full).....................: 99.97%

DBCC SHOWCONTIG scanning 'Saveset' table...

Table: 'Saveset' (117575457); index ID: 5, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 132822

- Extents Scanned..............................: 16646

- Extent Switches..............................: 27766

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 59.79% [16603:27767]

- Logical Scan Fragmentation ..................: 12.64%

- Extent Scan Fragmentation ...................: 24.69%

- Avg. Bytes Free per Page.....................: 107.4

- Avg. Page Density (full).....................: 98.67%

DBCC SHOWCONTIG scanning 'Saveset' table...

Table: 'Saveset' (117575457); index ID: 13, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 135713

- Extents Scanned..............................: 17012

- Extent Switches..............................: 33975

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 49.93% [16965:33976]

- Logical Scan Fragmentation ..................: 15.60%

- Extent Scan Fragmentation ...................: 33.87%

- Avg. Bytes Free per Page.....................: 1580.6

- Avg. Page Density (full).....................: 80.47%

DBCC SHOWCONTIG scanning 'SavesetProperty' table...

Table: 'SavesetProperty' (133575514); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1425034

- Extents Scanned..............................: 178438

- Extent Switches..............................: 189400

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 94.05% [178130:189401]

- Logical Scan Fragmentation ..................: 2.60%

- Extent Scan Fragmentation ...................: 18.16%

- Avg. Bytes Free per Page.....................: 657.7

- Avg. Page Density (full).....................: 91.87%

DBCC SHOWCONTIG scanning 'SavesetProperty' table...

Table: 'SavesetProperty' (133575514); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 361754

- Extents Scanned..............................: 45245

- Extent Switches..............................: 45397

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 99.61% [45220:45398]

- Logical Scan Fragmentation ..................: 0.58%

- Extent Scan Fragmentation ...................: 7.65%

- Avg. Bytes Free per Page.....................: 3351.7

- Avg. Page Density (full).....................: 58.59%

DBCC SHOWCONTIG scanning 'SavesetStore' table...

Table: 'SavesetStore' (149575571); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'Vault' table...

Table: 'Vault' (165575628); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 13122

- Extents Scanned..............................: 1643

- Extent Switches..............................: 1643

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 99.82% [1641:1644]

- Logical Scan Fragmentation ..................: 0.04%

- Extent Scan Fragmentation ...................: 16.86%

- Avg. Bytes Free per Page.....................: 1080.5

- Avg. Page Density (full).....................: 86.65%

DBCC SHOWCONTIG scanning 'Vault' table...

Table: 'Vault' (165575628); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 5696

- Extents Scanned..............................: 725

- Extent Switches..............................: 729

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 97.53% [712:730]

- Logical Scan Fragmentation ..................: 0.90%

- Extent Scan Fragmentation ...................: 25.24%

- Avg. Bytes Free per Page.....................: 15.1

- Avg. Page Density (full).....................: 99.81%

DBCC SHOWCONTIG scanning 'Vault' table...

Table: 'Vault' (165575628); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 6750

- Extents Scanned..............................: 854

- Extent Switches..............................: 1220

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 69.12% [844:1221]

- Logical Scan Fragmentation ..................: 6.39%

- Extent Scan Fragmentation ...................: 13.70%

- Avg. Bytes Free per Page.....................: 1276.9

- Avg. Page Density (full).....................: 84.22%

DBCC SHOWCONTIG scanning 'WatchFile' table...

Table: 'WatchFile' (181575685); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 31810

- Extents Scanned..............................: 3993

- Extent Switches..............................: 3995

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 99.52% [3977:3996]

- Logical Scan Fragmentation ..................: 0.29%

- Extent Scan Fragmentation ...................: 62.48%

- Avg. Bytes Free per Page.....................: 52.4

- Avg. Page Density (full).....................: 99.35%

DBCC SHOWCONTIG scanning 'WatchFile' table...

Table: 'WatchFile' (181575685); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 10712

- Extents Scanned..............................: 1339

- Extent Switches..............................: 1338

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1339:1339]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 31.44%

- Avg. Bytes Free per Page.....................: 3081.7

- Avg. Page Density (full).....................: 61.93%

DBCC SHOWCONTIG scanning 'WatchFile' table...

Table: 'WatchFile' (181575685); index ID: 4, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 23127

- Extents Scanned..............................: 2891

- Extent Switches..............................: 2890

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [2891:2891]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 28.50%

- Avg. Bytes Free per Page.....................: 61.8

- Avg. Page Density (full).....................: 99.24%

DBCC SHOWCONTIG scanning 'WatchFile' table...

Table: 'WatchFile' (181575685); index ID: 5, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 27045

- Extents Scanned..............................: 3381

- Extent Switches..............................: 3380

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [3381:3381]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 93.14%

- Avg. Bytes Free per Page.....................: 16.8

- Avg. Page Density (full).....................: 99.79%

DBCC SHOWCONTIG scanning 'WatchFile' table...

Table: 'WatchFile' (181575685); index ID: 6, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 3333

- Extents Scanned..............................: 426

- Extent Switches..............................: 455

- Avg. Pages per Extent........................: 7.8

- Scan Density [Best Count:Actual Count].......: 91.45% [417:456]

- Logical Scan Fragmentation ..................: 10.50%

- Extent Scan Fragmentation ...................: 99.30%

- Avg. Bytes Free per Page.....................: 388.5

- Avg. Page Density (full).....................: 95.20%

DBCC SHOWCONTIG scanning 'PartitionCache' table...

Table: 'PartitionCache' (407672500); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 7856.0

- Avg. Page Density (full).....................: 2.94%

DBCC SHOWCONTIG scanning 'ArchiveSummary' table...

Table: 'ArchiveSummary' (439672614); index ID: 0, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'ArchiveSummary_Cache' table...

Table: 'ArchiveSummary_Cache' (519672899); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8041.0

- Avg. Page Density (full).....................: 0.65%

DBCC SHOWCONTIG scanning 'ArchiveSummary_Cache' table...

Table: 'ArchiveSummary_Cache' (519672899); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8074.0

- Avg. Page Density (full).....................: 0.25%

DBCC SHOWCONTIG scanning 'ArchiveSummary_Cache' table...

Table: 'ArchiveSummary_Cache' (519672899); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8077.0

- Avg. Page Density (full).....................: 0.21%

DBCC SHOWCONTIG scanning 'ArchiveUsageSummary' table...

Table: 'ArchiveUsageSummary' (535672956); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 6

- Extents Scanned..............................: 5

- Extent Switches..............................: 5

- Avg. Pages per Extent........................: 1.2

- Scan Density [Best Count:Actual Count].......: 16.67% [1:6]

- Logical Scan Fragmentation ..................: 83.33%

- Extent Scan Fragmentation ...................: 80.00%

- Avg. Bytes Free per Page.....................: 640.8

- Avg. Page Density (full).....................: 92.08%

DBCC SHOWCONTIG scanning 'ArchiveUsageTimeBasedSummary' table...

Table: 'ArchiveUsageTimeBasedSummary' (551673013); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 35

- Extents Scanned..............................: 5

- Extent Switches..............................: 4

- Avg. Pages per Extent........................: 7.0

- Scan Density [Best Count:Actual Count].......: 100.00% [5:5]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 60.00%

- Avg. Bytes Free per Page.....................: 227.6

- Avg. Page Density (full).....................: 97.19%

DBCC SHOWCONTIG scanning 'ArchiveUsageTimeBasedSummary' table...

Table: 'ArchiveUsageTimeBasedSummary' (551673013); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 30

- Extents Scanned..............................: 4

- Extent Switches..............................: 3

- Avg. Pages per Extent........................: 7.5

- Scan Density [Best Count:Actual Count].......: 100.00% [4:4]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 50.00%

- Avg. Bytes Free per Page.....................: 227.6

- Avg. Page Density (full).....................: 97.19%

DBCC SHOWCONTIG scanning 'ArchiveUsageTimeBasedSummary' table...

Table: 'ArchiveUsageTimeBasedSummary' (551673013); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 30

- Extents Scanned..............................: 4

- Extent Switches..............................: 3

- Avg. Pages per Extent........................: 7.5

- Scan Density [Best Count:Actual Count].......: 100.00% [4:4]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 50.00%

- Avg. Bytes Free per Page.....................: 227.6

- Avg. Page Density (full).....................: 97.19%

DBCC SHOWCONTIG scanning 'ArchiveUsageSummaryByFileType' table...

Table: 'ArchiveUsageSummaryByFileType' (583673127); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 40

- Extents Scanned..............................: 9

- Extent Switches..............................: 12

- Avg. Pages per Extent........................: 4.4

- Scan Density [Best Count:Actual Count].......: 38.46% [5:13]

- Logical Scan Fragmentation ..................: 20.00%

- Extent Scan Fragmentation ...................: 11.11%

- Avg. Bytes Free per Page.....................: 585.8

- Avg. Page Density (full).....................: 92.76%

DBCC SHOWCONTIG scanning 'SISPart' table...

Table: 'SISPart' (594101157); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'SISPart' table...

Table: 'SISPart' (594101157); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'ArchiveSummaryRetention' table...

Table: 'ArchiveSummaryRetention' (599673184); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8040.0

- Avg. Page Density (full).....................: 0.67%

DBCC SHOWCONTIG scanning 'Saveset_SISPart' table...

Table: 'Saveset_SISPart' (626101271); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'Saveset_SISPart' table...

Table: 'Saveset_SISPart' (626101271); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'ConfigSettings' table...

Table: 'ConfigSettings' (631673298); index ID: 0, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 7442.0

- Avg. Page Density (full).....................: 8.06%

DBCC SHOWCONTIG scanning 'ConfigSettings' table...

Table: 'ConfigSettings' (631673298); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 7908.0

- Avg. Page Density (full).....................: 2.30%

DBCC SHOWCONTIG scanning 'WatchSISPartFile' table...

Table: 'WatchSISPartFile' (690101499); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'JournalUpdate' table...

Table: 'JournalUpdate' (738101670); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 2455

- Extents Scanned..............................: 307

- Extent Switches..............................: 306

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 100.00% [307:307]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 64.17%

- Avg. Bytes Free per Page.....................: 177.3

- Avg. Page Density (full).....................: 97.81%

DBCC SHOWCONTIG scanning 'JournalUpdate' table...

Table: 'JournalUpdate' (738101670); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 137

- Extents Scanned..............................: 18

- Extent Switches..............................: 17

- Avg. Pages per Extent........................: 7.6

- Scan Density [Best Count:Actual Count].......: 100.00% [18:18]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 83.33%

- Avg. Bytes Free per Page.....................: 33.2

- Avg. Page Density (full).....................: 99.59%

DBCC SHOWCONTIG scanning 'JournalUpdate' table...

Table: 'JournalUpdate' (738101670); index ID: 12, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 173

- Extents Scanned..............................: 22

- Extent Switches..............................: 21

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 100.00% [22:22]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 45.45%

- Avg. Bytes Free per Page.....................: 8.4

- Avg. Page Density (full).....................: 99.90%

DBCC SHOWCONTIG scanning 'JournalStub' table...

Table: 'JournalStub' (866102126); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'JournalStub' table...

Table: 'JournalStub' (866102126); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'JournalStub' table...

Table: 'JournalStub' (866102126); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'JournalStub' table...

Table: 'JournalStub' (866102126); index ID: 5, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'VersionInfo' table...

Table: 'VersionInfo' (965578478); index ID: 0, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8083.0

- Avg. Page Density (full).....................: 0.14%

DBCC SHOWCONTIG scanning 'VersionInfo' table...

Table: 'VersionInfo' (965578478); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8081.0

- Avg. Page Density (full).....................: 0.16%

DBCC SHOWCONTIG scanning 'UnrelatedArchiveVault' table...

Table: 'UnrelatedArchiveVault' (1058102810); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 7727.0

- Avg. Page Density (full).....................: 4.53%

DBCC SHOWCONTIG scanning 'sysdiagrams' table...

Table: 'sysdiagrams' (1678629023); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'sysdiagrams' table...

Table: 'sysdiagrams' (1678629023); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HashAlgorithmInfo' table...

Table: 'HashAlgorithmInfo' (1838629593); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 1

- Extents Scanned..............................: 1

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 1.0

- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 8069.0

- Avg. Page Density (full).....................: 0.31%

DBCC SHOWCONTIG scanning 'tmp_ArchiveUsageSummaryByFileType' table...

Table: 'tmp_ArchiveUsageSummaryByFileType' (1972202076); index ID: 0, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 305

- Extents Scanned..............................: 43

- Extent Switches..............................: 42

- Avg. Pages per Extent........................: 7.1

- Scan Density [Best Count:Actual Count].......: 90.70% [39:43]

- Extent Scan Fragmentation ...................: 16.28%

- Avg. Bytes Free per Page.....................: 57.2

- Avg. Page Density (full).....................: 99.29%

DBCC SHOWCONTIG scanning 'tmp_ArchiveUsageSummaryByFileType' table...

Table: 'tmp_ArchiveUsageSummaryByFileType' (1972202076); index ID: 4, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 161

- Extents Scanned..............................: 21

- Extent Switches..............................: 20

- Avg. Pages per Extent........................: 7.7

- Scan Density [Best Count:Actual Count].......: 100.00% [21:21]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 9.52%

- Avg. Bytes Free per Page.....................: 55.9

- Avg. Page Density (full).....................: 99.31%

DBCC SHOWCONTIG scanning 'tmp_ArchiveUsageSummaryByFileType' table...

Table: 'tmp_ArchiveUsageSummaryByFileType' (1972202076); index ID: 5, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 105

- Extents Scanned..............................: 18

- Extent Switches..............................: 36

- Avg. Pages per Extent........................: 5.8

- Scan Density [Best Count:Actual Count].......: 37.84% [14:37]

- Logical Scan Fragmentation ..................: 26.67%

- Extent Scan Fragmentation ...................: 38.89%

- Avg. Bytes Free per Page.....................: 2260.6

- Avg. Page Density (full).....................: 72.07%

DBCC SHOWCONTIG scanning 'ArchivePoint' table...

Table: 'ArchivePoint' (2073058421); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 15

- Extents Scanned..............................: 8

- Extent Switches..............................: 7

- Avg. Pages per Extent........................: 1.9

- Scan Density [Best Count:Actual Count].......: 25.00% [2:8]

- Logical Scan Fragmentation ..................: 46.67%

- Extent Scan Fragmentation ...................: 87.50%

- Avg. Bytes Free per Page.....................: 39.0

- Avg. Page Density (full).....................: 99.52%

DBCC SHOWCONTIG scanning 'ArchivePoint' table...

Table: 'ArchivePoint' (2073058421); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 9

- Extents Scanned..............................: 8

- Extent Switches..............................: 7

- Avg. Pages per Extent........................: 1.1

- Scan Density [Best Count:Actual Count].......: 25.00% [2:8]

- Logical Scan Fragmentation ..................: 77.78%

- Extent Scan Fragmentation ...................: 87.50%

- Avg. Bytes Free per Page.....................: 550.6

- Avg. Page Density (full).....................: 93.20%

DBCC SHOWCONTIG scanning 'Collection' table...

Table: 'Collection' (2089058478); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'Collection' table...

Table: 'Collection' (2089058478); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'Collection' table...

Table: 'Collection' (2089058478); index ID: 3, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'Collection' table...

Table: 'Collection' (2089058478); index ID: 6, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'FSAVaultProperties' table...

Table: 'FSAVaultProperties' (2105058535); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 2665

- Extents Scanned..............................: 351

- Extent Switches..............................: 355

- Avg. Pages per Extent........................: 7.6

- Scan Density [Best Count:Actual Count].......: 93.82% [334:356]

- Logical Scan Fragmentation ..................: 1.84%

- Extent Scan Fragmentation ...................: 26.21%

- Avg. Bytes Free per Page.....................: 13.5

- Avg. Page Density (full).....................: 99.83%

DBCC SHOWCONTIG scanning 'FSAVaultProperties' table...

Table: 'FSAVaultProperties' (2105058535); index ID: 4, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 1036

- Extents Scanned..............................: 149

- Extent Switches..............................: 160

- Avg. Pages per Extent........................: 7.0

- Scan Density [Best Count:Actual Count].......: 80.75% [130:161]

- Logical Scan Fragmentation ..................: 4.54%

- Extent Scan Fragmentation ...................: 32.89%

- Avg. Bytes Free per Page.....................: 47.7

- Avg. Page Density (full).....................: 99.41%

DBCC SHOWCONTIG scanning 'HoldConsumer' table...

Table: 'HoldConsumer' (2121058592); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldConsumer' table...

Table: 'HoldConsumer' (2121058592); index ID: 2, database ID: 14

LEAF level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC SHOWCONTIG scanning 'HoldData' table...

Table: 'HoldData' (2137058649); index ID: 1, database ID: 14

TABLE level scan performed.

- Pages Scanned................................: 0

- Extents Scanned..............................: 0

- Extent Switches..............................: 0

- Avg. Pages per Extent........................: 0.0

- Scan Density [Best Count:Actual Count].......: 100.00% [0:0]

- Logical Scan Fragmentation ..................: 0.00%

- Extent Scan Fragmentation ...................: 0.00%

- Avg. Bytes Free per Page.....................: 0.0

- Avg. Page Density (full).....................: 0.00%

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
     

     

  • GabeV's avatar
    GabeV
    Level 6
    11 years ago

    John,

    Looking at that DBCC output, the only tables I see it has high frag is JournalArchive and Saveset:

    DBCC SHOWCONTIG scanning 'JournalArchive' table...
Table: 'JournalArchive' (37575172); index ID: 6, database ID: 14
LEAF level scan performed.
- Pages Scanned................................: 14653
- Extents Scanned..............................: 1840
- Extent Switches..............................: 5419
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 33.80% [1832:5420]
- Logical Scan Fragmentation ..................: 27.63%
- Extent Scan Fragmentation ...................: 67.50%
- Avg. Bytes Free per Page.....................: 3792.8
- Avg. Page Density (full).....................: 53.14%

DBCC SHOWCONTIG scanning 'Saveset' table...
Table: 'Saveset' (117575457); index ID: 5, database ID: 14
LEAF level scan performed.
- Pages Scanned................................: 132822
- Extents Scanned..............................: 16646
- Extent Switches..............................: 27766
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 59.79% [16603:27767]
- Logical Scan Fragmentation ..................: 12.64%
- Extent Scan Fragmentation ...................: 24.69%
- Avg. Bytes Free per Page.....................: 107.4
- Avg. Page Density (full).....................: 98.67%

DBCC SHOWCONTIG scanning 'Saveset' table...
Table: 'Saveset' (117575457); index ID: 13, database ID: 14
LEAF level scan performed.
- Pages Scanned................................: 135713
- Extents Scanned..............................: 17012
- Extent Switches..............................: 33975
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 49.93% [16965:33976]
- Logical Scan Fragmentation ..................: 15.60%
- Extent Scan Fragmentation ...................: 33.87%
- Avg. Bytes Free per Page.....................: 1580.6
- Avg. Page Density (full).....................: 80.47%

    You can reorganize/rebuild these indexes manually from SQL Management Studio. If you are not familiar with this process, take a look at this technote and use the SQL script to rebuild any index with fragmentation over 10% *(or reorganize any index under 10%):

    SQL Index Fragmentation and Statistics
    http://www.symantec.com/docs/TECH168905

    If after running that script you still see high fragmentation, you might need to get Microsoft to deep a little bit more on this.

    I hope this helps.

  • AndrewB's avatar
    AndrewB
    Moderator
    11 years ago

    hi john, wanted to see if you're still dealing with this issue. there are some other sql scripts i've found to be far superior to the builtin maintenance plans. let me know how things are working out for you.