January 18, 2010 at 2:03 pm
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.
January 18, 2010 at 7:20 pm
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
January 18, 2010 at 10:16 pm
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[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply