Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Server Administration Expand / Collapse
Author
Message
Posted Thursday, January 7, 2010 10:45 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 8:42 AM
Points: 481, Visits: 318
Comments posted to this topic are about the item Server Administration

Swarndeep

http://talksql.blogspot.com
Post #844101
Posted Thursday, January 7, 2010 11:44 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 6:44 PM
Points: 1,280, Visits: 1,760
I selected "nothing" however I've had issues in the past with the default "max server memory" setting being set at 2147483647 MB on 64 bit systems. Setting the max to a level less than the total OS memory has improved performance on a number of boxes.
Post #844122
Posted Friday, January 8, 2010 2:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 7, 2013 4:37 AM
Points: 256, Visits: 224

Hi foxxo

Nice TIP.
Any idea Why this improve performance ??
Post #844163
Posted Friday, January 8, 2010 2:58 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 7:17 AM
Points: 1,608, Visits: 374
3 GB Switch is supported for 32 bit editions. It tell operating system to allocate 2 GB RAM to OS and 2 GB RAM to other program such as SQL Or Exchange, if 4 GB RAM is installed.

Well, almost. MSDN (http://msdn.microsoft.com/en-us/library/ms791558.aspx) states
On 32-bit versions of Windows, the /3GB parameter enables 4 GT RAM Tuning, a feature that enlarges the user-mode virtual address space to 3 GB and restricts the kernel-mode components to the remaining 1 GB.

Anyway, thanks for the good question. These are parameters considered rather seldomly which may heavily affect the performance of your system.



Best regards,
Dietmar Weickert.
Post #844175
Posted Friday, January 8, 2010 7:24 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
foxxo (1/7/2010)
I selected "nothing" however I've had issues in the past with the default "max server memory" setting being set at 2147483647 MB on 64 bit systems. Setting the max to a level less than the total OS memory has improved performance on a number of boxes.


That has been my experience as well. Thanks for bringing that up.
Post #844293
Posted Friday, January 8, 2010 8:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:13 AM
Points: 2,917, Visits: 2,536
It has been ours aw well. It appears that if one reserves the minimum memory necessary to make the OS happy, and anything else that may be running - then take the rest for SQL Server, things work mor harmoniously. It will also redice to some point some of the system performance issues as it works with what it is told to use. As long as the OS has enough memory to not utilize paging it is happy. This is actually a throwback to the early years when SQL Server was Sybase. After MS took over at the version they did, they made a lot of rule changes to try to distance themselves. MS and I had numerous arguments over best practices and they finally conformed

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #844394
Posted Friday, January 8, 2010 9:05 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
Glenn Berry has a good article on the subject on this site.

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx
Post #844402
Posted Friday, January 8, 2010 9:42 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 14, 2010 6:13 PM
Points: 44, Visits: 933
yes, the question would be better if talked about: what do you need to do for sql server recognize more than 2GB of memory in an 64bit environment?

to allocate the max memory available on the windows server is a suicide..



---------------------
Alex Rosa
http://www.keep-learning.com/blog
Post #844457
Posted Friday, January 8, 2010 10:37 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 10:46 AM
Points: 911, Visits: 831
There should be a 4th option: set the maximum Memory SQL can use.
Post #844516
Posted Friday, January 8, 2010 10:56 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 17,947, Visits: 15,941
Thanks for the question



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #844527
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse