February 2, 2010 at 10:56 am
Paul White (2/2/2010)
TheSQLGuru (2/2/2010)
That says to me it is acceptable to set them equal. And not having to wait for memory grants can be beneficial in some cases.Oh it is - don't get me wrong, I was just providing the reference asked for. People who know what they're doing can certainly set them the same for any number of good reasons. Personally, I tend to default to setting min lower than max - but it's not a rule I'm married to by any means 🙂
Something tickled the back of my mind on this one that there was an important reason for giving the engine some breathing room between the min and max settings. I was hoping you were going to point to that reference. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 2, 2010 at 11:02 am
TheSQLGuru (2/2/2010)
Something tickled the back of my mind on this one that there was an important reason for giving the engine some breathing room between the min and max settings. I was hoping you were going to point to that reference. 🙂
Hmmm yes. I can't think where that is offhand, though it is a widely-held view, as you know. Darn it, I'm going to have to go look now - it's gonna bug me otherwise.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
February 2, 2010 at 12:39 pm
Paul White (2/2/2010)
TheSQLGuru (2/2/2010)
Something tickled the back of my mind on this one that there was an important reason for giving the engine some breathing room between the min and max settings. I was hoping you were going to point to that reference. 🙂Hmmm yes. I can't think where that is offhand, though it is a widely-held view, as you know. Darn it, I'm going to have to go look now - it's gonna bug me otherwise.
I am completely wrapped up in a complex project rollout/babysit or I would be looking myself.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 3, 2010 at 9:50 am
hello there, im not familiar with sql so please help me
our server is windows server 2008 standard edition, 4gb ram, 2x250gb hdd raid
with sql server 2005
the problem is,
after 3 to 5 days the server is getting slow or worse user cant connect at all,
physical memory is stack at 95% , the sqlserver.exe process in task manager goes up to 2,000 something
then the server become slow after the sqlserver.exe process in task manager is decreasing until it reaches to 400 going down
connecting to the system is very slow, normal operation after we restart the server
try the max and min option but to no avail
max memory=2000
min memory=48
please help me, every 3 days we have to restart the server
thank you
February 3, 2010 at 10:12 am
carloparcon (2/3/2010)
hello there, im not familiar with sql so please help meour server is windows server 2008 standard edition, 4gb ram, 2x250gb hdd raid
with sql server 2005
the problem is,
after 3 to 5 days the server is getting slow or worse user cant connect at all,
physical memory is stack at 95% , the sqlserver.exe process in task manager goes up to 2,000 something
then the server become slow after the sqlserver.exe process in task manager is decreasing until it reaches to 400 going down
connecting to the system is very slow, normal operation after we restart the server
try the max and min option but to no avail
max memory=2000
min memory=48
please help me, every 3 days we have to restart the server
thank you
This question has nothing to do with this thread. Please post it as a separate question on its own thread in one of the SQL2008 forums on this site.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply