RE: Sql priority

You're probably on the right track.  Most of the work done in the Vault
Server is done by SQL Server, and the Web Service never tries to do anything
while it's making a request of the SQL Server.  Encouraging SQL Server to
hog resources will probably help performance.

I've had limited success with the "Boost SQL Server priority on Windows"
setting in Enterprise Manager.

I'll deal with Eric offline. :)

-Jeremy

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Eric Sink
Sent: Friday, February 20, 2004 3:49 PM
To: 'SourceGear Vault MailList'
Subject: RE: [vault-list] Sql priority


Prediction:

SourceGear's Profiling Fanatic (Jeremy Sheeley) 
will soon respond to this note and remind us all
that the only way to really know how performance 
will be affected by a change is to actually make 
that change and then measure the difference.

:-)

--
Eric Sink
Software Craftsman
http://software.ericsink.com/

 
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Scott LaFave
Sent: Friday, February 20, 2004 1:20 PM
To: SourceGear Vault MailList ([email protected])
Subject: [vault-list] Sql priority

If we have vault and sql on the same server (dedicated), does anyone have an
opinion on boosting sql priority on the server?  I was thinking since sql is
probably where most of the performance hit is on large operations, maybe it
would make sense to favor it when the machine is busy.

 

Scott LaFave, MCSD

Software Architect

TReND

660 American Avenue, Suite 203

King of Prussia, PA 19406

E-mail: [email protected]

Phone: 610.783.4650 x177

Fax: 610.783.4695

Web: www.trendmls.com

 


_______________________________________________
vault-list mailing list
[email protected]
http://lists.sourcegear.com/cgi-bin/mailman/listinfo/vault-list