Tuesday, 3 November 2009

SQL Server Memory Settings 64bit

Rather interesting blog posting here talking about SQL Server 2005/2008 64bit and memory settings. The recommendation is to always set these as the following table outlines:

Physical RAMMaxServerMem Setting
2GB1500
4GB3200
6GB4800
8GB6400
12GB10000
16GB13500
24GB21500
32GB29000
48GB44000
64GB60000
72GB68000
96GB92000
128GB124000


What makes this interesting is the comments posted, where one poster mentions that they have seen instability when the memory is not set.
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)