Recommendation for high-performance get latest.

[hwapdc]

Vault Version Version 6.1.0.531
Running on dedicated Windows Server: Windows Server 2008 R2, 4 CPU, 16 GB RAM
Vault DBs at HP Server Xenon E5620 (4 cores, 8 threads), Windows Server 2008 R2 32 GB RAM, SQL Server 2008 R2.
I need some advise to configure Vault for optimal performance of our "robots"
I have around 20 (and rising) robots ( Virtual Machines with Vault Client)
Every robot do a get-latets and gets around 10.000 files, compile program and do some tests.
After every test is completed the robot is rebooted and reverted to startup configuration.
At peak hours a robot is starting every 5 s. This put a lot of stress on Vault Server and Database Server.
Network utilization at Vault Server is 100 % (1GBit/s), CPU is moderate. SQL server is under heavy CPU stress often it runs for hours at 100% CPU. The SQL server network output is 1 GBit/s (it is able to output 4 GBit/s)

I have followed the SQL performance guide lines in
http://support.sourcegear.com/viewtopic.php?t=2924 and http://support.sourcegear.com/viewtopic ... 13&t=21402

vault.config (vault_config.txt) is attached below.

Vault log contains many entries like:

----17-03-2013 00:06:33 Read_Only--robot14.pdc.xx(10.117.68.3)--SSL Disabled System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (see details in attached vaultlog.txt)


Some times users are complaining of long check-in times.

How can I increase performance?
Would Shadow folder increase performance?
My understanding is that Shadow Folders will cache files at the Vault Server.
Can I make sure no one makes any changes to files in Shadow Folders? I need to be sure that every changed file is checked-in (stored in database).
Any hints appreciated

[Beth]

Shadow folders aren't a performance booster. They just copy down a copy of the latest code that is checked in to some disk location that you specify.

We have a KB article on performance here: http://support.sourcegear.com/viewtopic.php?t=4206. Try those suggestions first.