Forum Discussion

James_Slack's avatar
11 years ago

Vault items "Awaiting Backup" not cleairing down

Hi, There is a web page I use to monitor items awaiting backup, the Vault Store Usage Reporter. This is indicating we are now up to 6 million items awaiting backup - and growing! We use the tri...
  • GabeV's avatar
    11 years ago

    James,

    Take a look at this technote:

    SQL Index Fragmentation and Statistics
    http://www.symantec.com/docs/TECH168905

    Basically, you need to run the following SQL query:

    DBCC SHOWCONTIG WITH ALL_INDEXES

    The technote above has more details of what you need to look for in the output. Keep in mind that if you have high fragmentation, you need to run a SQL maintenance to fix it. That will improve the EV performance. If that's the case (i.e. there is high fragmentation in SQL) , you need to read this technote:

    How to automatically back up and perform recommended maintenance for Enterprise Vault SQL databases
    http://www.symantec.com/docs/TECH74666

    Forward it to the team that is in charge of the SQL server maintenance to confirm if they are following the correct steps.