The performance of certain content center operations are substantially slower when Microsoft SQL Server 2005 is being used. This hotfix resolves the performance issue.
Warning A migration of the databse must be performed after applying this patch. See instructions below.
Installation Instructions
Begin with Autodesk Data Management Server 5 SP1 installed.
Open Vault Manager and make sure all databases are fully migrated to the latest version. If not, please migrate them before proceeding.
Close the Vault Manager application.
Download TS1070133.zip hotfix.
Extract the file to a temporary directory on your server.
Double-click on TS1070133.exe to install the hotfix.
Open a command prompt and navigate to the installed location of Connectivity.VaultManager.Exe
Run Vault Manager b2bmigrate operation in command line mode: Ex: Connectivity.VaultManager.Exe -Ob2bmigrate -DBUsa -BPAutodeskVault (the last two cmdline parameters are required only if the ‘sa’ password is not the default "AutodeskVault" password)
When the 'migration successful' dialog displays the hotfix is complete.
AUTODESK DOES NOT GUARANTEE THAT YOU WILL BE ABLE TO SUCCESSFULLY DOWNLOAD OR IMPLEMENT ANY SERVICE PACK OR WORKAROUND, OR ANY OF THE TIPS, TRICKS, EXAMPLES OR SUGGESTIONS OUTLINED IN ANY AUTODESK PRODUCT SUPPORT TECHNICAL DOCUMENTS. TECHNICAL DOCUMENTS, SERVICE PACKS AND WORKAROUNDS ARE SUBJECT TO CHANGE WITHOUT NOTICE TO YOU. AUTODESK PROVIDES TECHNICAL DOCUMENTS, SERVICE PACKS AND WORKAROUNDS "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL AUTODESK OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF DATA, OR LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, THAT MAY OCCUR AS A RESULT OF IMPLEMENTING ANY SERVICE PACK OR WORKAROUND, OR ANY SUGGESTION OUTLINED IN ANY AUTODESK PRODUCT SUPPORT TECHNICAL DOCUMENT, EVEN IF AUTODESK OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.