Wednesday, March 9, 2011

Grid is populated very slowly in Vault Explorer 2008

Issue
When you selected a folder in Vault Explorer, you noticed that it was populated very slowly with the information from the files that it contains.
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

   4. Where <VAULTNAME> is the name of your VaultSave 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.

1 comment:

  1. It is populated with about 3000 rows and redraws very slowly. If I minimize and maximize my Form all the other controls.

    ReplyDelete