Vault General Discussion

Vault General Discussion

Reply
Contributor
TomAllen
Posts: 22
Registered: ‎04-21-2008
Message 1 of 3 (661 Views)

What version of SQL Server is best for 2013?

661 Views, 2 Replies
06-15-2012 11:18 AM

We are curently running Vault 2010 ADMS with a full version of SQL Server 2005

(Microsoft SQL Server Management Studio    9.00.3042.00)

 

We are preparing to move to Vault ADMS 2013, the system requirements dictate SQL 2008.

 

I was wondering if anyone had any experience or thoughts on which version is best for Vault

 

Server:

Microsoft Windows Server 2003R2 (X64) SP2

Intel Xeon Quad E5450 @ 3.00 GHz

20 GB Ram

 

Vault Database is about 5GB's

Filestore is just over 200GB's

 

We tried Express way back when and I know it has limitations, database size.. etc.

 

but there is:

 

Microsoft SQL Server 2008 Workgroup Edition

Microsoft SQL Server 2008 Standard
Microsoft SQL Server 2008 R2 Standard

 

Small Workgroup >10 users, stability and performance being the priority.

 

Does anyone know which version is "appropriate" or offers any advantages from the given info?

 

Thanks in advance for any time you can afford me with this.

 

Employee
rantisong
Posts: 57
Registered: ‎07-30-2008
Message 2 of 3 (605 Views)

Re: What version of SQL Server is best for 2013?

06-20-2012 09:24 AM in reply to: TomAllen

According to configration of the machine, I don't think Workgroup edition is a good idea, since Workgroup can only utilize 4GB RAM in your computer. For SQL to Standard edition, the supported max size of RAM is upto 64GB.  Given this, Standard edition should be a good choice for you.

 

Thanks,

Frank

Vault 2013 Wiki help is ALIVE !
Contributor
TomAllen
Posts: 22
Registered: ‎04-21-2008
Message 3 of 3 (583 Views)

Re: What version of SQL Server is best for 2013?

06-21-2012 10:43 AM in reply to: TomAllen

Thanks for your input Frank, it is greatly appreciated.

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.