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: Monday, December 8, 2014 10:20 AM
Points: 170, Visits: 235
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:00 PM
Points: 18,060, Visits: 16,093
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #849500
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse