Browsing in Vault 2012 is much slower for me than it was in Vault 2011. When I click on a folder, it takes several seconds for the information to come up. In Vault 2011, it was almost instant. I'm not talking about large folders with thousands of files in them. Most of them have only a couple hundred files in the folder. It is just frustrating having to wait.
I have also saved a search folder to find checked-out files. It takes it about 10-15 seconds to show the search results.
This installation is using a local vault, so it has nothing to do with the network speed. Running windows 7x64 and the SQL Express that is installed with ADMS.
Is it just me... or is this what I'm going to have to live with in Vault 2012?
It sounds like you have a support request logged against the purge defect. Hopefully I will see the hotfix "if" they release one. Would you mind updating this thread "if" they issue a hotfix?
Thanks
Yes a support request is open by Autodesk. I will put the link here when the hotfix is released.
Have noticed that Vault now waits until all status and property values are updated before displaying the file-list. In previous versions the file-list was dibsplayed and then the updated with correct file-status and property data.
In the prevoius versions the user could start navigating and scrolling through the lists in an earlier stage. Now they have to wait a few seconds longer. This partly explains the slow grid in Vault Explorer but the open-dialog in Inventor is also very slow so I guess its more into it than just delayed diplaying of the files.
Are you still waiting for a fix for this issue? Did either TS17309387 or TS17313115 fix the grid display problem? I havent tried either hotfix to see.
It did not help for my cusotmer.
They have a folder with 3000 idw files in it and a subfolder containg 4300 parts and assemblies
When accessing this it takes about 10-25 seconds to update the file list in vault exporer but that's the biggest problem.
When they want to access an ipt/iam file from from inventor they have first goto the idw folder to accessthe subfolder containg the ipt/iam. In Inventor it takes about 25-60 seconds before the files in the first folder to appear and about the same time for the files in the subfolder.
This is an old thread, but is the problem solved? Did autodesk released a hotfix for this problem?
The Vault Performance Hotfix (ts17309387) does not solve my customers problem. Also a re-index, defragmentation, security on the mdf and ldf does not solve their problem.
Can somebody update this thread with the Autodesk Support case?
Kind regard,
Having the same problem with 2011. Logged a call with our reseller about it. Not really getting anywhere fast though. Our slow down was overnight and seemed to coincide with a fairly large windows update (this may be a coincidence). We have tried disabling our anti-virus etc but no luck. The issues began around the 9th September.
Update - we posted an earlier message to this problem.
We found the problem happened straight after we upgraded from Inv 2011 to Inv 2012.
& Microsoft SQL 2005 to 2008.
Note also we did a purge on Vault after our upgrade.
previously we listed that rebuilding index fixed problem. It seemed to fix it ( but it was only for a day )
We have tried everything else - de- installing all other software on server ( including virus software ) to no avail.
At this point we are out of ideas and very frustrated.
The only thing that I can think of at this point that may work is
1 - to rebuild the server & do a restore
or
2 - Rebuild the server & use autoloader to reload vault
Sigh ............Who has the time to do this!!!! Autodesk perhaps!!
I just installed Vault Collaboration 2012 (ADMS) on a Windows Server 2008 R2 64-Bit machine running SQL 2008 R2 Enterprise (no Service Pack 1 as it's not supported) with 56 GB of RAM,
I restored a filestore and database from Vault 2011 running SQL Express 2008. I took the database from SQL Express 2008 to SQL Express 2008 R2 and then up to SQL 2008 R2 Enterprise as this is the required upgrade path for SQL.
I installed Vault Collaboration (client) on my Windows 7 64 Bit client machine and when accessing the root of the Vault or any folder for that matter, it displays "Searching" and takes about a minute to populate the grid.
The old server with Vault 2011 is still up and running and when I connect to that, it has absolutely no issues like this at all.
I have tried a number of things to resolve on the issue on the 2012 Vault. I would have expected this setup to run circles around the old hardware and configuration as the current 2011 Vault is running on a Windows Server 2003 32 bit machine with 3.5 GB of RAM.
Tried:
- Applied SP1 for Vault Collaboration 2012
- Ran SQL Maintenance Plan
- Defrag on Database
- Delete Indexes folder and Rebuild Search Indexes
- Detach and Reattach Database inside Vault
- Applied AutodeskVault, Network Service and Local Admin account Full access to Application, FileStore and Database partitions
- No Anti-Virus Scanning
Current File Store and Database:
FS: 56.00 GB
DB: 5.50 GB
Partition Configuration:
C:\ Application Files (ADMS, SQL, etc...)
D:\ Databases (KVM, Vault and Content Center MDF)
E:\ Logs (SQL LDF and Content Center LDF)
F:\ FileStore (Vault CAD data)
I am out of options at this point. Has anyone been able to resolve this issue?
Look at the early post in this thread posted on 9/1/2011.
Basically the older vault version strated to show the user info as it received it from the query and allowed the user to scroll through as it was being loaded. Autodesk changed it so that now it will not show the user anything until ALL of the data is downloaded from the vault server including preview icons, etc. My guess is that you have a fair number of entries in each folder. So if you do have a large number of entries in each folder this is a killer.
Not sure why Autodesk would make such a change however their testing obviously did not test for the case of having a flat file directory, which is what our original dealer suggested we do when we first installed back in 2009.
I do not think this is the issue entirely. There is a setting within the ADMS Console which allows you to change the number of items to show on a page in the Vault client within a range from 25-1000. I have set this to 25, so displaying 25 items on a page is not a large task at all. The other difference with 2012 is that it does show folders in the grid view as well as files. I am going to change the filter to only show files to see if this helps.
If I improve this at all I will report back. Thank you for your response.
-Matt
I dont think that is your problem either. There would have to be thousands of files in the one directory for it to take that long. Just curious though, how many files are in the directory you are trying to display?
One on my largest folders has about 2000 files and it takes only a few seconds to load all the data the first time I click on it. If I go to a different folder and come back to this one, it loads much quicker the next time.
Time it takes once clicking on the Root or a folder:
Project Explorer ($) - 3 Folders - 1 File - 36 Seconds
Project (Folder) - 11 Folders - 1 File - 2 Mins 38 Seconds
The weird thing is, if I do a search on that folder or on the Root, it displays quick like it should. It's just when it's populating the main grid just by clicking on a folder.
Also, the Web Client takes a long time to login intially and about the same time (maybe a little less) when you click on the same Project folder above.
I'm working with Autodesk right now to try and get this resolved. Initially we thought it was an IIS issue, but we created another dummy Vault, (of course it didn't have any data in it except a few files and folders) and logging in via the Web Client and clicking on the folder in the thick client displayed like normal. We are now thinking it's a database issue. I'm uploading the database to them tonight for further investigation. I pray I get this fixed. This is going to be unacceptable if we cannot resolve it.
I am experiencing the same annoying problem with one of our customers.
They have a pretty big Vault database, 12.5Gb . With Vault 2011 they didn't experience any problem at all, everything worked like a charm and it was really fast.
After upgrading to Vault 2012+SQL 2008 Full SP2, same hardware of the server, same hardware on the clients, same configuration, same antiviruses, etc etc...everything went down the hill: the grid takes ages to popullate and show up, even for little folders, the normal operations of checkin/checkout are incredibly slow, and until now I haven't found a solution yet.
I have already tried almost all the solutions provided in the other posts in this thread, without any luck.
The only thing I haven't tried yet is the SQL maintenance plan, but I read that others tried it with no success.
I will let you know if we find a solution: in the meanwhile, the customer is very angry with Autodesk and is already checking how to migrate everything to a competitor software...
Dave
What I have found to fix this issue is to modify the memory usage inside SQL. By default SQL will use as much memory as it can get it hands on. If you set a limit, the performance seems to increase.
Log into SQL Management Studio
Right-Click the AutodeskVault Instance
Properties
Memory
I have found success with using a value of 8192 (8GB).
I have also found using anything above this value brought the issue back. Autodesk claims this is an issue with Microsoft SQL and 64 Bit OS.
Let me know if you see success by modifying this value.
Dave,
Along with the suggestion posted by Matt (SQL x64 only), also look into setting up / verifying the SQL maintenance plan. Additionally, any exceptions that were set in the AV software will need to be updated to reflect the 2012 product line - IE, if you have an exception set for C:\Program Files\Autodesk\ADMS 2011\ADMS Console\Connectivity.admsconsole.exe, it will need to be updated to reflect the 2012 console executible.
Hello,
You set the limit to 8Gb. Does it depend on the amount of physical RAM of the server?
Thanks in advance.
Yes, it does. Set it accordingly to how much you have on the system The system I had been working with had 56GB of RAM. It was disappointing to know I could only use 8GB of that for SQL.
I solved my problem.
This is what I did; it could lead to solution also with your similar problems:
- I checked in the IIS, and I noticed that the Default Website was using the ASP.NET 1.0 instead of the 2.0, and corrected the mistake
- I stopped and restarted the MSSQL$AUTODESKVAULT service
- I configured the list of researchable properties of the files, diminishing their number ( I didn't deactivate them, just made them not searchable)
- Defragged the DB
- Scheduled an SQL maintenance plan, following the instructions in the Advanced Configuration Guide of Autodesk Vault
Of all the above things what really helped in improving the performances was the stopping and restart of the SQL service. The SQL tends to grow in size inside the RAM of the server, and when it reaches around 2 Gb it begun to slow down the whole service. In my case, it took at least 8 hours to reach that size, even with no customers working (i.e. at night).
The solution was scheduling this 2 lines of code which run every MORNING at 07:00am before the customers get in office. In this way, they aways begin to work with a clean SQL service, fresh and just started and everything works like a charm.
Those are the 2 lines to stop and restart the service (put them in a .BAT and use the scheduled operations of windows to run it every morning):
net stop MSSQL$AUTODESKVAULT /Y
net start MSSQL$AUTODESKVAULT
the /Y is needed to run it in silent mode; otherwise it would ask if you are sure.
I hope it will help you solve some of your performance problems too.
Cheers,
Davide
Can't find what you're looking for? Ask the community or share your knowledge.