Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql Server Configuration change-URGENT Expand / Collapse
Author
Message
Posted Monday, January 18, 2010 2:03 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
Do we need to restart the Sql Server /Agent, when you change the Max memory , Min memory , Min Memory per query , Set the fill factor to 90% , Set network packet size to new size via studio management instead of SP_Configure command? please reply back asap. Thanks a lot.
Post #849389
Posted Monday, January 18, 2010 7:20 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 2:15 PM
Points: 170, Visits: 222
hydbadrose (1/18/2010)
Do we need to restart the Sql Server /Agent, when you change the Max memory , Min memory , Min Memory per query , Set the fill factor to 90% , Set network packet size to new size via studio management instead of SP_Configure command? please reply back asap. Thanks a lot.


I think you posted this in the wrong Forum...(this is for 2K5 T-SQL)


Kev -=Conan The Canadian=-
@ConanTheCdn
Post #849478
Posted Monday, January 18, 2010 10:16 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:42 PM
Points: 20,473, Visits: 14,120
hydbadrose (1/18/2010)
Do we need to restart the Sql Server /Agent, when you change the Max memory , Min memory , Min Memory per query , Set the fill factor to 90% , Set network packet size to new size via studio management instead of SP_Configure command? please reply back asap. Thanks a lot.



Of the options listed, the only one that requires a restart is the fill factor (and potentially changing max memory to a smaller value).
http://msdn.microsoft.com/en-us/library/aa196706(SQL.80).aspx Article is for 2K, should be good for 2005 on these settings listed.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #849500
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse