Edward-445599
Hall of Fame
Points: 3147
More actions
February 5, 2008 at 9:18 am
#71306
I have just run sp_configure and I have gotten this result for max server memmory.
max server memory (MB)4214748364765546554
I thought the default was 2147483647 but I am showing 6554!? Have i misunderstood this? What does it mean. Many thanks
Steve Jones - SSC Editor
SSC Guru
Points: 728164
February 5, 2008 at 9:25 am
#775196
Where did you get this value? If you run something like sp_configure, you'll see the configured value in the third column, meaning someone has changed it. by default, I think it's at the max and the server manages memory.
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply