Re: SQL 2000 Standard & RAM
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/21/05
- Next message: skitrees: "IIS and SQL - Clarified question"
- Previous message: Andrew J. Kelly: "Re: Clustered Indexes"
- In reply to: CW3: "Re: SQL 2000 Standard & RAM"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 20 Feb 2005 23:16:50 -0500
Task manager is not the right tool to look for memory consumption in sql
server. Use perfmon and the associated sql memory counters for that. But
in a nut shell what you are seeing (or not seeing ) is the memtoleave area.
This is a section of memory that sql server reserves on startup to use for
such things as worker threads, xp's, OLEDB, extended queries etc. It does
not show in task manager and as such it appears that sql server is only
using around 1.7GB. The memtoleave will use up to 384MB by default. So in
actuality you are using all 2GB. Std Edition can not use more than 2
regardless of how much you have and it will ignore the /3GB switch. Have a
look at this:
http://msdn.microsoft.com/SQL/sqlarchitecture/?pull=/library/en-us/dnsqldev/html/sqldev_01262004.asp
-- Andrew J. Kelly SQL MVP "CW3" <cwilson@3mc.com> wrote in message news:euq5h26FFHA.548@TK2MSFTNGP14.phx.gbl... > The previous answers are correct according to the BOL, but I have a > question > about this 2GB limit. We have a server running Win2K sp4 with SQL2K SE > and > 3GBs of RAM. I have set the server to use the max of RAM as well as set > it > to use 2GBs of RAM. According to the task manager I have never been able > to > get the SQL Server service to use more than 1,743,628K. The Total Server > Memory counter from the SQLServer:Memory Mgr counter is reporting > 1,683,432K > used. This server use to have only 2GBs of physical memory, and we added > another 1GB of memory in the hopes of getting SQL to "really use" 2GBs > while > the OS uses the remaining 1GB of memory. After adding the extra memory, > it > doesn't appear to have changed (as seen from the task manager) the amount > of > physical memory SQL uses. > > So my question is, can SQL2K SE running on the standard edition of Win2K > really use up to 2GBs of memory? > > (I saw a ref in another post about using the /3GB switch even though I > have > the SE of SQL. I have not set this /3GB switch in the boot.ini because I > know this edition cannot use AWE memory.) > > "Jiøí Lejsek" <jlejsek@na_volnym_v_cesku> wrote in message > news:u7ASqB4FFHA.3368@TK2MSFTNGP10.phx.gbl... >> Hello, >> >> does anybody know how it is with MSSQL Server 2000 Stadard Edition and >> RAM >> restriction for the whole computer? >> >> I know, that SQL Server can use maximum of 2 GB of RAM, but I heard that > it >> limits available memory to the whole computer to 2 GB RAM. >> Does anybody use MSSQL Server Standard with more than 2 GB RAM on a >> computer? (And what is maximum RAM usage?) >> >> Thanks, >> J. Lejsek >> >> > >
- Next message: skitrees: "IIS and SQL - Clarified question"
- Previous message: Andrew J. Kelly: "Re: Clustered Indexes"
- In reply to: CW3: "Re: SQL 2000 Standard & RAM"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
