Vault General Discussion

Vault General Discussion

Reply
Contributor
tomasz.kut
Posts: 11
Registered: ‎05-27-2009
Message 1 of 4 (614 Views)

SQL express more then 10GB - is possible? Vault very slow!

614 Views, 3 Replies
09-23-2011 11:29 AM

Hallo everybody,

 

We have problem with performance on our vault server 2011 - sql 2008 express on win server 2008 R2. I know that R2 isn't supported but after migration 2010-10 we haven't so big problem with performance.

 

We are 8 users working on the INV2011 connected to vault. We migrated  always data base from older version to new version. I know that sql express is limited to 10GB data base. About 3 months ago it's begin working very slow  - INV + vault + content center - I have check ADMS console and vaults SQL databases was 4GB and  libraries database was 14,5GB. Is it possible that after migration sql databases was less then 10GB and later grow and grow and now we have problem? How works sql express then databases  exceeds 10GB?   



Tomasz Kut

Win7-64; AIP2014
DEll T3610 - Quadro K4000 - 16Gb
Product Support
Richard.Rankin
Posts: 134
Registered: ‎03-25-2010
Message 2 of 4 (589 Views)

Re: SQL express more then 10GB - is possible? Vault very slow!

09-26-2011 03:47 AM in reply to: tomasz.kut

It is very possible that the SQL DB will increase in size following a migration.

 

You could try running the SQL Maintenance plan defined in the Advance Config guide. Part of it involves setting the Recovery Model to Simple, where applicable.

 

You could also try looking at this blog post

http://crackingthevault.typepad.com/crackingthevault/2010/06/how-toreduce-vault-size-and-generally-i...

 

Give those a try but failing that, you may be faced with having to upgrade your SQL. I hope this helps.

 

 


______________________________________________________________

If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!

 



Richard Rankin
Data Management Support Specialist
Autodesk Support
Autodesk, Inc.

Product Support
Richard.Rankin
Posts: 134
Registered: ‎03-25-2010
Message 3 of 4 (587 Views)

Re: SQL express more then 10GB - is possible? Vault very slow!

09-26-2011 03:49 AM in reply to: Richard.Rankin

Sorry I forgot to give you a link to the Advanced Config Guide

http://images.autodesk.com/adsk/files/advanced_config_guide_-_2012.pdf

 

See page 25



Richard Rankin
Data Management Support Specialist
Autodesk Support
Autodesk, Inc.

Contributor
tomasz.kut
Posts: 11
Registered: ‎05-27-2009
Message 4 of 4 (548 Views)

Re: SQL express more then 10GB - is possible? Vault very slow!

10-09-2011 01:41 AM in reply to: Richard.Rankin

thanks Richard for yours advices, they are very usefully information

 

In my case it will be maintenance script for Vault 2011, I have one from ACG-2011.

 

I have questions:

Is it correct that I

1-start script from cmd VaultMaintenance.bat  %YourVault%>results.txt

-should all users(vault clients) login out or can they be connected   

2-reboot vault server

3-can be problems with performance on INV during reindex properties on the vault server?

4- should I remove the IPv6  even I have installed LNM (FLEXnet) for 2012 products family?



Tomasz Kut

Win7-64; AIP2014
DEll T3610 - Quadro K4000 - 16Gb
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.

Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.