I've been reading a lot of the posts about memory but I'm still unclear.
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3G
B
if it needs it?
Thanks.
RonHi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more tha
n
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment