Re: Sql Server - Memory Question

Sorry about that.... ;-)

Thanks to you and all who responded. These newsgroups are a valuable
tool......

First off, the orders are in and won't be modified. The rational is that we
are "financing" them and the impact on our annual budget is small.... Next,
we've talked with our database vendor and they say that their application
will use the memory above 2GB if needed. Lastly, with 4GB we will have more
flexibility if we decide to re-deploy the servers for other purposes....

--
Regards,
Hank Arnold

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:eoq53hrYFHA.2076@xxxxxxxxxxxxxxxxxxxxxxx
> I was hoping you wouldn't question that<g>. If you are running SQL Std
> Edition on other than Win2K Std (Adv, Win2K3 etc) and set the /3GB switch
> it may be possible for the MemToLeave portion which is up to 386MB's to
> live above the 2GB. But the memory pool which is most of the usage can
> not go above 2GB. For the most part 2GB is all you will see SQL Server
> use regardless of how much ram is on the box. Approx 1.7 for the memory
> pool and the rest for the MemToLeave.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Hank Arnold" <rasilon@xxxxxxx> wrote in message
> news:OXZS9epYFHA.2768@xxxxxxxxxxxxxxxxxxxxxxx
>> "Essentially"??
>>
>> --
>> Regards,
>> Hank Arnold
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
>> news:OaJj9EkYFHA.2900@xxxxxxxxxxxxxxxxxxxxxxx
>>> That is essentially correct.
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>>
>>>
>>> "Hank Arnold" <rasilon@xxxxxxx> wrote in message
>>> news:O9sOQ$iYFHA.616@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Am I correct in my reading that SQL2000 Standard will not support
>>>> memory above 2GB?
>>>>
>>>> Hank
>>>>
>>>> "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
>>>> news:%233m8bBiYFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> Without AWE enabled you will only use up to 3GB of memory if you have
>>>>> the /3GB switch in the boot.ini which is looks like you do. The
>>>>> reason you see 2.7 is that there is a section of memory referred to as
>>>>> the Memory To Leave or MemToLEave that uses up to 384MB. The MAX
>>>>> Memory setting is for the buffer pool only and does not include the
>>>>> MemToLEave. Task manager is not hte proper tool to use for monitoring
>>>>> memory usage. Use Perfmon for that and the SQL Server memory counters.
>>>>> If you want to use 4GB for the memory pool then you must enable AWE.
>>>>>
>>>>>
>>>>> http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk
>>>>> Memory
>>>>> http://www.sql-server-performance.com/awe_memory.asp Using AWE
>>>>> Memory
>>>>> http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000
>>>>> memory usage
>>>>> http://www.support.microsoft.com/?id=274750 Memory config
>>>>> http://www.support.microsoft.com/?id=283037 Large Memory
>>>>> Support Is Available in Windows 2000 (AWE)
>>>>> http://www.support.microsoft.com/?id=811891 Can not use more than 2GB
>>>>> of memory
>>>>>
>>>>>
>>>>> --
>>>>> Andrew J. Kelly SQL MVP
>>>>>
>>>>>
>>>>> "Alex P." <AlexP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>>>> news:FB6EC4AC-8FE4-4949-84EA-A7AD7444FECD@xxxxxxxxxxxxxxxx
>>>>>> Hi All.
>>>>>> I have a question about the Sql Server Memory Usage in my server.
>>>>>> I have a server with:
>>>>>> win2000 sp4,sql server 2000 sp3a,RAM = 6143MB,WIN VIRTUAL MEMORY =
>>>>>> 2046MB,sql Server Memory configuration: (Dinamically) Min = 0MB
>>>>>> MAX=4096MB
>>>>>>
>>>>>> The server is exclusively for sql server.
>>>>>> Always, after restart, sqlserver uses in RAM about 300MB, but after 5
>>>>>> minutes, i see in the Task Manager that the sqlserver.exe has used
>>>>>> 2.7GB of
>>>>>> memory. the value remains without processes running. If i decrement
>>>>>> max
>>>>>> memory to 3000MB, the value still remains.
>>>>>>
>>>>>> My question is: is the SqlServer using all this 2.7GB of memory? this
>>>>>> one
>>>>>> behavior is normal?
>>>>>>
>>>>>> Thanks for your help.
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Clustered W2K3 Server Memory
    ... SS also uses another memory segment know as MEM TO ... With more than 4GB, then you MUST use PAE, whether or not Win2K3 enables ... Andrew J. Kelly SQL MVP "Chris Wood" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Clustered W2K3 Server Memory
    ... SS also uses another memory segment know as MEM TO ... With more than 4GB, then you MUST use PAE, whether or not Win2K3 enables ... Andrew J. Kelly SQL MVP "Chris Wood" wrote in message ...
    (microsoft.public.sqlserver.setup)
  • Re: Memory settings on 2005 32 bit where >4gb ram?
    ... I read on one article that setting helped performance starting up. ... Andrew J. Kelly SQL MVP ... Process physical/virtual memory pressure: 0/0 System physical memory ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Memory - The SQL Server can not use more than 2GB
    ... Andrew J. Kelly SQL MVP ... If so you may want to open a case with MS PSS. ... Available Physical Memory: 3,033,316 KB ...
    (microsoft.public.sqlserver.server)
  • Re: How to correctly use /PAE and AWE
    ... Andrew J. Kelly SQL MVP ... > AWE is physical memory too! ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)
Loading