SQL Server Performance Forum – Threads Archive
Dynamically configure memory
HiI have 4 G physical memory When i checked server property ->memory
I noticed that dynamically configure memory range is from 2G to 3 G
Why not from 0 to 4 ? Is there a reason for that?
thank you
What is the edition of SQL Server?
Normally 1GB leaves out to the OS if sQL memory settings chosen to leave as Dynamic. For exact counters take help from PERFMON. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
SQL eddition: Microsoft SQL Server 2000 – 8.00.765 (Intel X86)
Feb 7 2003 17:33:51
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
EE is for Win2K and run XP_MSVER to full details on SQL. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
If is a dedicated SQL Server, better configure memory statically, lets say 3GB for SQL 1GB for OS.
I would never go with static memory allocation until unless any requirement of OS, as a thumb rule better to leave it for dynamic allocation. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>