Vault General Discussion

Vault General Discussion

Reply
Contributor
cvdcage
Posts: 13
Registered: ‎01-09-2014
Message 1 of 3 (208 Views)
Accepted Solution

Installing Vault 2014 SQL recommendations

208 Views, 2 Replies
02-24-2014 03:00 AM

Hello,

 

We are installing Vault Professional on a brand new VMWare environment. We are installing Vault on a Windows 2012 configuration and are planning to use SQL 2012.

 

I cannot seem to find any documentation wether or not to keep the SQL server on a seperate machine. 

 

What is the recommended (and supported) configuration? Some documentation states that a single machine for Files, SQL and IIS is recommended: http://download.autodesk.com/us/vault/2014/2014_Advanced_Config_Guide-2014.pdf (page 32) and http://download.autodesk.com/global/inventor/Vault_Best_Practices_Whitepaper.pdf which is an old document and seems to be copied to the new guide...

 

Best regards,

Christiaan

 

Also, is http://crackingthevault.typepad.com/crackingthevault/2009/07/what-is-the-best-raid-configuration-to-... still valid for Vault 2014?

 

HI Christiaan,

 

For simplicity's sake, the same server for all components is usually easiest and is performant as long as you are not running a number of other business critical applications on the same machine.  Splitting SQL from the file server is supported and can have some performance benefits, often though this configuration decision is driven by corporate IT policy rather than big performance gains.  Your replication strategy (if any) may also play a role in this planning.

 

Nothing much has changed in RAID recommendations - this guide should reflect current guidelines.   RAID 10 being the better but less economic configuration, RAID 5 with only 3 disks being among the worst.

Employee
olearya
Posts: 657
Registered: ‎08-14-2008
Message 2 of 3 (165 Views)

Re: Installing Vault 2014 SQL recommendations

02-25-2014 09:33 AM in reply to: cvdcage

HI Christiaan,

 

For simplicity's sake, the same server for all components is usually easiest and is performant as long as you are not running a number of other business critical applications on the same machine.  Splitting SQL from the file server is supported and can have some performance benefits, often though this configuration decision is driven by corporate IT policy rather than big performance gains.  Your replication strategy (if any) may also play a role in this planning.

 

Nothing much has changed in RAID recommendations - this guide should reflect current guidelines.   RAID 10 being the better but less economic configuration, RAID 5 with only 3 disks being among the worst.



Allan
Product Manager
Autodesk, Inc.
Contributor
cvdcage
Posts: 13
Registered: ‎01-09-2014
Message 3 of 3 (159 Views)

Re: Installing Vault 2014 SQL recommendations

02-25-2014 09:50 AM in reply to: olearya

Hi Allan,

Thanks for your answer. We'll use this server as a dedicated server for Vault. We have no intention of using the SQL server for anything else. The discussion we've had with our IT dept. is that SQL tends to eat a lot of memory and this may affect the IIS and Application services of Vault.

I think we'll go for a single server deployment with a RAID 10 disk set.

Thanks!

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.
Need installation help?

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