Performance questions
Scott LaFave <[email protected]> Tue, 16 Mar 2004 10:36:32 -0500
| Newsgroups | gmane.comp.version-control.sourcegear-vault.user |
|---|---|
| Message-ID | <[email protected]> |
Hi all- We are setting up a new dedicated Vault server to run version 2. It's running Win 2003 and Sql 2000 SP3a. I have 2 questions on performance settings. 1st, the box will be running both the Vault service and the Vault database. The box has 2 gb of ram. Does anyone recommend restricting the max memory available to Sql Server so that the system and the Vault web site have memory reserved for them? If so, restricting sql max mem to what? 2nd, how much use does Vault make of tempdb? Is there any benefit to trying to isolate tempdb on its own drive? The Vault db itself already will have its own dedicated transaction log drive. If I do not isolate tempdb, it will live on the same drive as the Vault mdf data file. The transaction log drive is RAID 10, the data drive is RAID 5. Thanks ahead of time for any suggestions! Scott LaFave, MCSD Software Development Manager TReND 660 American Avenue, Suite 203 King of Prussia, PA 19406 E-mail: [email protected] <mailto:[email protected]> Phone: 610.783.4650 x3377 Fax: 610.783.4695 Web: www.trendmls.com <http://www.trendmls.com>