Grid is populated very slowly in Vault Explorer 2008

Issue

Solution

This may occur if the statistical information used by SQL to run certain queries is out of date. As a result, the grid is populated using an SQL query that is processed in an inefficient manner, causing a noticeable delay.

It is strongly recommend that you implement a Maintenance Plan as described in the Advanced Configuration Guide for ADMS 2008, which can be downloaded from the following web page:

Advanced Configuration Guide for ADMS 2008

In addition, it may be necessary to manually update the statistics for the Vault database. To do so, follow these steps:

1. Using Microsoft® Notepad, create a new text file and insert the following text:

osql.exe -S(local)\AUTODESKVAULT -Usa -P"AutodeskVault" -i UpdateStatistics.sql -o results.txt
NET STOP MSSQL$AUTODESKVAULT
NET START MSSQL$AUTODESKVAULT


2. Save the file as "osql.bat".
3. Create another text file and insert the following text:


Use KnowledgeVaultMaster
Exec sp_MSForEachTable 'Update Statistics ? WITH FULLSCAN'
Go
Use <VAULTNAME>
Exec sp_MSForEachTable 'Update Statistics ? WITH FULLSCAN'
Go

Where <VAULTNAME> is the name of your Vault
4. Save the file as "UpdateStatistics.sql" (in the same folder as the file "osql.bat").
5. Run the "osql.bat" file and then inspect the Results.txt file for any errors.