RE: Sql priority

Thanks to everyone for the responses I got.  I'll think I'll just leave it
at normal priority for the moment.  :-)

-----Original Message-----
From: Michael J. Carter [mailto:[email protected]] 
Sent: Monday, February 23, 2004 10:26 AM
To: SourceGear Vault MailList
Subject: RE: [vault-list] Sql priority

Interesting blog about the "Boost Performance" option.

http://blogs.msdn.com/michael_platt/archive/2004/02/13/72360.aspx

 
 
Michael J. Carter, MCP
Sr. Software Engineer
Advanced Health Media, Inc.
tel: 757-274-1009
fax: 757-687-8488
cel: 757-580-0910
[email protected]
 
 

-----Original Message-----
From: Jeremy Sheeley [mailto:[email protected]] 
Sent: Friday, February 20, 2004 5:01 PM
To: 'SourceGear Vault MailList'
Subject: RE: [vault-list] 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

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

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