Video Screencast Help

Enterprise Vault maintenance on SQL Server which cause outage ?

Created: 10 Dec 2013 | 10 comments

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.

Operating Systems:

Comments 10 CommentsJump to latest comment

Advisor's picture

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.

Advisor's picture

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 picture

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.

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

Advisor's picture

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.

John Santana's picture

Hi Advisor, thanks for the clarification.

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

EnterpriseVaultDirectory
EVVaultstore1

or both ?

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

Advisor's picture

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 picture

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.
 

 

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

Trafford's picture

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 Gowing - Symantec EV Exchange STS

DFA Solutions

Cape Town

GabeV's picture

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.

“Success is not final, failure is not fatal: it is the courage to continue that counts.”–Winston Churchill

AndrewB's picture

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.

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com