Optimal Vault Server Hardware Configuration

Dan Edgar · Post by **Dan Edgar** » Fri Jul 07, 2006 11:37 am

I have an existing SQL Server cluster that hosts my Vault database, so optimization there is probably not available.

However, I would like to throw hardware at my Vault server to improve performance.

I have ~20+ simultaneous Vault users.

I am looking to optimize Get and Branch operations.

Should I optimize my Vault Service / IIS service hosting hardware for disk access (ex. RAID 0+1 15K RPM SCSI)? Memory(ex 16GB RAM)?

What settings can I apply to the Vault service and / or IIS to optimize Vault?

Are there command line tweaks that I can apply to Get and Branch operations that will speed up the process?

I am looking for any and all hardware / setting / software tweaks and recommendations for Vault performance speed up.

Any help is appreciated,
--Dan Edgar

Post by **jclausius** » Fri Jul 07, 2006 12:27 pm

Dan:

Beefing up your Vault Server box will help in general operations (Refresh), but if you profile GET or BRANCH operations, you will see most of the work is performed by SQL Server.

Now, I don't want to diminish the importance of plenty of memory for the Vault Server (1 to 2 GB should be more than ample for around 50 users), but most of the work is done within the Data Tier really hitting SQL Server.

Ensuring SQL Server is on a very, very fast disk subsystem, and performing database maintenace (Statistics and Rebuilding/Defragging Indices) will ensure Vault is in working order.