Memory More than 2G ==> 3GB switch

All,
We have a dell system with 2 processors(4 by the technique of
hyperthreading) and 4 GB of RAM.
This system is fully dedicated to SQL 2000 sp 3a, hotfix 818.
I have added the /3GB switch into the boot.ini and set the memory of
SQL fixed to 3043 MB RAM.
The problem is the following :
I think that my server isn't using the 3 Gig of Memory for
applications because of 2 reasons
- the error initdata: Warning: Could not set working set size to
1353312 KB.
- sqlserveragent agentlog [310] 4 processor(s) and 2048 MB RAM
detected
I know that sqlserveragent is not the same as sqlserver but I expect
then that the sqlserveragent should detect 1GB or 3GB - 3 is most
likely- and not 2 GB.
2 GB should be normal if the /3GB switch isn't used.
Question:
How can i really check if the 3 GB switch is activated and working.
I have found a document at microsoft but that link doesnt clarify
because on a server and on an enterprise edition the pagedpoolsize is
the same .
s/Default.asp?url=/resources/documentation/windowsServ/2003/all/techref/en-us/w2k3
tr_4gt_tools.asp" target="_blank">http://www.microsoft.com/resources/...r_4gt_tools.aspHi
This feature will work on Windows 2000 DataCenter or Advenced Server
machines. Do you have SQL Server installed on one of them?
<romaric_decoene@.yahoo.com> wrote in message
news:e4d6707e.0405240241.706d25f1@.posting.google.com...
> All,
> We have a dell system with 2 processors(4 by the technique of
> hyperthreading) and 4 GB of RAM.
> This system is fully dedicated to SQL 2000 sp 3a, hotfix 818.
> I have added the /3GB switch into the boot.ini and set the memory of
> SQL fixed to 3043 MB RAM.
> The problem is the following :
> I think that my server isn't using the 3 Gig of Memory for
> applications because of 2 reasons
> - the error initdata: Warning: Could not set working set size to
> 1353312 KB.
> - sqlserveragent agentlog [310] 4 processor(s) and 2048 MB RAM
> detected
> I know that sqlserveragent is not the same as sqlserver but I expect
> then that the sqlserveragent should detect 1GB or 3GB - 3 is most
> likely- and not 2 GB.
> 2 GB should be normal if the /3GB switch isn't used.
> Question:
> How can i really check if the 3 GB switch is activated and working.
> I have found a document at microsoft but that link doesnt clarify
> because on a server and on an enterprise edition the pagedpoolsize is
> the same .
>
http://www.microsoft.com/resources/...2003/all/techre
f/en-us/Default.asp?url=/resources/documentation/windowsServ/2003/all/techre
f/en-us/w2k3tr_4gt_tools.asp|||What edition of the OS and SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<romaric_decoene@.yahoo.com> wrote in message news:e4d6707e.0405240241.706d25f1@.posting.googl
e.com...
> All,
> We have a dell system with 2 processors(4 by the technique of
> hyperthreading) and 4 GB of RAM.
> This system is fully dedicated to SQL 2000 sp 3a, hotfix 818.
> I have added the /3GB switch into the boot.ini and set the memory of
> SQL fixed to 3043 MB RAM.
> The problem is the following :
> I think that my server isn't using the 3 Gig of Memory for
> applications because of 2 reasons
> - the error initdata: Warning: Could not set working set size to
> 1353312 KB.
> - sqlserveragent agentlog [310] 4 processor(s) and 2048 MB RAM
> detected
> I know that sqlserveragent is not the same as sqlserver but I expect
> then that the sqlserveragent should detect 1GB or 3GB - 3 is most
> likely- and not 2 GB.
> 2 GB should be normal if the /3GB switch isn't used.
> Question:
> How can i really check if the 3 GB switch is activated and working.
> I have found a document at microsoft but that link doesnt clarify
> because on a server and on an enterprise edition the pagedpoolsize is
> the same .
>
s/Default.asp?url=/resources/documentation/windowsServ/2003/all/techref/en-us/w2k3
tr_4gt_tools.asp" target="_blank">http://www.microsoft.com/resources/...r_4gt_tools.asp|||- sqlserveragent agentlog [310] 4 processor(s) and 2048 MB RAM
detected
SQL Agent can't see more than 2 GB regardless of what SQL Server can see but
incorrectly reports what it can see rather than the amount of memory on the
server and is independent of what SQL Server can address.
Do you have Advanced Server and SQL2000 EE ?
Have you specified the "set working set size" ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<romaric_decoene@.yahoo.com> wrote in message
news:e4d6707e.0405240241.706d25f1@.posting.google.com...
> All,
> We have a dell system with 2 processors(4 by the technique of
> hyperthreading) and 4 GB of RAM.
> This system is fully dedicated to SQL 2000 sp 3a, hotfix 818.
> I have added the /3GB switch into the boot.ini and set the memory of
> SQL fixed to 3043 MB RAM.
> The problem is the following :
> I think that my server isn't using the 3 Gig of Memory for
> applications because of 2 reasons
> - the error initdata: Warning: Could not set working set size to
> 1353312 KB.
> - sqlserveragent agentlog [310] 4 processor(s) and 2048 MB RAM
> detected
> I know that sqlserveragent is not the same as sqlserver but I expect
> then that the sqlserveragent should detect 1GB or 3GB - 3 is most
> likely- and not 2 GB.
> 2 GB should be normal if the /3GB switch isn't used.
> Question:
> How can i really check if the 3 GB switch is activated and working.
> I have found a document at microsoft but that link doesnt clarify
> because on a server and on an enterprise edition the pagedpoolsize is
> the same .
>
s/Default.asp?url=/resources/documentation/windowsServ/2003/all/techre" target="_blank">http://www.microsoft.com/resources/...2003/all/techre
f/en-us/w2k3tr_4gt_tools.asp|||We are running Windows 2003 Enterprise Server with SQL 2000 Enterprise
edition.
The working set size is set to 1
Does this mean that SQLserver agent can't see that the 3gb switch is
enabled and therefore suppose thats it is the standard 2Gb for
applications and 2 Gb for system? Will it then compete with sql server
service for memory or with the system ?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message news:<#ChXD0bQEHA.3456@.TK2MSFTNG
P11.phx.gbl>...
> - sqlserveragent agentlog [310] 4 processor(s) and 2048 MB RAM
> detected
> SQL Agent can't see more than 2 GB regardless of what SQL Server can see b
ut
> incorrectly reports what it can see rather than the amount of memory on th
e
> server and is independent of what SQL Server can address.
> Do you have Advanced Server and SQL2000 EE ?
> Have you specified the "set working set size" ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> <romaric_decoene@.yahoo.com> wrote in message
> news:e4d6707e.0405240241.706d25f1@.posting.google.com...
> -us/Default.asp?url=/resources/documentation/windowsServ/2003/all/techre" target="_blank">http://www.microsoft.com/resources/...2003/all/techre
> f/en-us/w2k3tr_4gt_tools.asp|||I would set the "set working set size" option to 0
exec sp_configure 'set working',0
reconfigure
and restart the server.
SQLAgent isn't large memory aware or compiled with the /3GB switch so it can
see the standard 2GB user mode address space that all normal win32 processes
can. It comptetes with SQL Server in the same sense that opening notepad on
the server does i.e. not much :-) it's all just virtual address space after
all.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<romaric_decoene@.yahoo.com> wrote in message
news:e4d6707e.0405250329.482e96a9@.posting.google.com...
> We are running Windows 2003 Enterprise Server with SQL 2000 Enterprise
> edition.
> The working set size is set to 1
> Does this mean that SQLserver agent can't see that the 3gb switch is
> enabled and therefore suppose thats it is the standard 2Gb for
> applications and 2 Gb for system? Will it then compete with sql server
> service for memory or with the system ?
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:<#ChXD0bQEHA.3456@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
but[vbcol=seagreen]
the[vbcol=seagreen]
l=/resources/documentation/windowsServ/2003/all/techre" target="_blank">http://www.microsoft.com/resources/...2003/all/techre[vbcol=seagreen]