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 Monday, January 11, 2010 9:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 5, 2014 1:57 PM
Points: 545, Visits: 643

I think what people should take away from this is that you want to get the memory settings on 64 bit correct; set Min/Max memory, and lock pages in memory. If the working set gets trimmed, performance is in the toilet.



Succinctly accurate.


"Beliefs" get in the way of learning.
Post #845506
Posted Tuesday, January 12, 2010 8:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 18, 2014 12:13 PM
Points: 2,837, Visits: 1,138
I've whined about misleading questions in the past, but this one seemed perfectly clear. It asked what was the best option to allocate maximum available RAM to SQL Server 64-bit. If you do nothing then it will grab all the memory it can.

This may be the wrong configuration for most servers in the real world, but the answer is not wrong. The question contained a very precise and unambiguous definition of what was meant by "best".



Post #846215
Posted Tuesday, January 12, 2010 8:32 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 5, 2014 1:57 PM
Points: 545, Visits: 643
That'll teach me to read the question a little more carefully. Of course, then we couldn't have had a fascinating discussion on AWE and Lock Pages in memory.

"Beliefs" get in the way of learning.
Post #846223
Posted Tuesday, January 12, 2010 8:35 AM


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
Thanks Scott.

Swarndeep

http://talksql.blogspot.com
Post #846227
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse