Sql Server Configuration change-URGENT

  • 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.

  • 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

  • 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