September 3, 2014 at 2:16 pm
Hi This is the message which I received when I executed this query
exec sp_configure 'show advanced options', 1
go
reconfigure
go
exec sp_configure 'max server memory', 4500
go
reconfigure
Configuration option 'max server memory (MB)' changed from 2147483647 to 4500. Run the RECONFIGURE statement to install.
what is this Run the RECONFIGURE statement to install? do I need to execute reconfigure again or what ?
please let me know.
September 3, 2014 at 2:22 pm
From MSDN:-
Specifies that if the configuration setting does not require a server stop and restart, the currently running value should be updated.
You've already run RECONFIGURE so don't worry. Best way to check is to right click your instance in SSMS (at the top), go to Properties, then Memory and then you can see if your updated value is there in Maximum Server Memory (in MB)
September 3, 2014 at 2:24 pm
Thank a lot for your reply.
September 3, 2014 at 2:24 pm
Since you already ran reconfigure, you shouldn't need to worry about that message. Think of it as a reminder that is displayed every time you change a config.
Just be sure to verify the setting is in effect.
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
September 3, 2014 at 2:27 pm
If you want to verify the current setting, run this statement:
EXEC sp_configure 'max server memory'
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply