/3GB SQL Server 2000

Hi,
I run SQL Server 2000 on Windows 2000 Server (4 GB memory) with 2
instances.
As I understand it, one instance can use a maximum of 2 GB of memory. If I
would use the /3GB switch in this environment, would that help me or is it
that this switch can only be used with the Advanced or Enterprise Edition
of SQL Server 2000 /w2K?
TIA
WombelYou need to run Windows 2000 Advanced Server or Data Center editions in
order to use the /3GB switch. See
http://support.microsoft.com/defaul...750&Product=sql
for more information.
Assuming you want both instances to use an equal amount of memory, you
wouldn't want to use /3GB anyway with only 4GB physical RAM. It's important
to have enough physical RAM to support the SQL Server memory requirements of
all instances running on the server.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Wrobel" <twrobel@.waslos.de> wrote in message
news:Xns94C3739FDCBEBtwrobelwaslosde@.207
.46.248.16...
> Hi,
> I run SQL Server 2000 on Windows 2000 Server (4 GB memory) with 2
> instances.
> As I understand it, one instance can use a maximum of 2 GB of memory. If I
> would use the /3GB switch in this environment, would that help me or is it
> that this switch can only be used with the Advanced or Enterprise Edition
> of SQL Server 2000 /w2K?
> TIA
> Wombel|||"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in
news:OrPWjb9GEHA.684@.tk2msftngp13.phx.gbl:

> You need to run Windows 2000 Advanced Server or Data Center editions
> in order to use the /3GB switch. See
> http://support.microsoft.com/defaul...274750&Product=
> sql for more information.
> Assuming you want both instances to use an equal amount of memory, you
> wouldn't want to use /3GB anyway with only 4GB physical RAM. It's
> important to have enough physical RAM to support the SQL Server memory
> requirements of all instances running on the server.
>
Dan,
thanks for your reply. Do you know if there is any difference when I user
Windows 2003 Server Standard?
TIA
Thomas|||> thanks for your reply. Do you know if there is any difference when I user
> Windows 2003 Server Standard?
As stated in MSKB 274750, you can use the /3GB boot.ini switch with Windows
2000 Server (Standard Edition).
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Wrobel" <twrobel@.waslos.de> wrote in message
news:Xns94C39FB4C54Etwrobelwaslosde@.207.46.248.16...
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in
> news:OrPWjb9GEHA.684@.tk2msftngp13.phx.gbl:
>
> Dan,
> thanks for your reply. Do you know if there is any difference when I user
> Windows 2003 Server Standard?
> TIA
> Thomassql

/3GB and Maximum server memory

Hi,
I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
server memory any higher than 2147483647. What should I do else? I presume I
should be able to set it until 3 gigabytes now?
Any help will be really appreciated,
Thansk a lot in advance,
Pieter
This is my boot.ini:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOW S
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windo ws Server 2003, Standard"
/noexecute=optout /fastdetect /3GB
With /3GB switch alone, you should be able to see SQLServer:Buffer
Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
(KB)--both measuring the buffer pool--reach more than 2GB. But you probably
won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL instance
hard enough for it to use more than what you reported.
See
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx for an exmaple.
BTW, how did you get the 2147483647 number?
Linchi
"Pieter" wrote:

> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
> server memory any higher than 2147483647. What should I do else? I presume I
> should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOW S
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windo ws Server 2003, Standard"
> /noexecute=optout /fastdetect /3GB
>
>
|||IIRC, that setting is in MEGABYTES, so it is far more than 4GB. Also,
you really should set the limit for this to about 2.5-3GB to keep from
starving the OS and other necessary items of RAM.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
news:u5h1fb6mIHA.3636@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe
> Maximum server memory any higher than 2147483647. What should I do else? I
> presume I should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOW S
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windo ws Server 2003,
> Standard" /noexecute=optout /fastdetect /3GB
>
|||Hi,
Indeed: In the mean time (when looking at the Task Manager) SQL Server is
using allmost 3 gigabytes, which is perfect!
Regarding the 2147483647: when you right click on the Server in the SQL
Server Management Studio, choose properties, and than Memory, you see the
Maximum server memory. But I guess it has nothing to do with it :-)
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:8DEA94EC-ACD9-4C2F-8C93-FE8B24FF7F94@.microsoft.com...[vbcol=seagreen]
> With /3GB switch alone, you should be able to see SQLServer:Buffer
> Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
> (KB)--both measuring the buffer pool--reach more than 2GB. But you
> probably
> won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL
> instance
> hard enough for it to use more than what you reported.
> See
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> for an exmaple.
> BTW, how did you get the 2147483647 number?
> Linchi
> "Pieter" wrote:

/3GB and Maximum server memory

Hi,
I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
server memory any higher than 2147483647. What should I do else? I presume I
should be able to set it until 3 gigabytes now?
Any help will be really appreciated,
Thansk a lot in advance,
Pieter
This is my boot.ini:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard"
/noexecute=optout /fastdetect /3GBWith /3GB switch alone, you should be able to see SQLServer:Buffer
Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
(KB)--both measuring the buffer pool--reach more than 2GB. But you probably
won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL instance
hard enough for it to use more than what you reported.
See
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx for an exmaple.
BTW, how did you get the 2147483647 number?
Linchi
"Pieter" wrote:
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe Maximum
> server memory any higher than 2147483647. What should I do else? I presume I
> should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard"
> /noexecute=optout /fastdetect /3GB
>
>|||IIRC, that setting is in MEGABYTES, so it is far more than 4GB. :) Also,
you really should set the limit for this to about 2.5-3GB to keep from
starving the OS and other necessary items of RAM.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
news:u5h1fb6mIHA.3636@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
> activated the /3GB switch in the boot.ini, but I still can't setthe
> Maximum server memory any higher than 2147483647. What should I do else? I
> presume I should be able to set it until 3 gigabytes now?
>
> Any help will be really appreciated,
>
> Thansk a lot in advance,
>
> Pieter
> This is my boot.ini:
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
> Standard" /noexecute=optout /fastdetect /3GB
>|||Hi,
Indeed: In the mean time (when looking at the Task Manager) SQL Server is
using allmost 3 gigabytes, which is perfect!
Regarding the 2147483647: when you right click on the Server in the SQL
Server Management Studio, choose properties, and than Memory, you see the
Maximum server memory. But I guess it has nothing to do with it :-)
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:8DEA94EC-ACD9-4C2F-8C93-FE8B24FF7F94@.microsoft.com...
> With /3GB switch alone, you should be able to see SQLServer:Buffer
> Manager\Total Pages or SQLServer:Memory Manager\Total Server Memory
> (KB)--both measuring the buffer pool--reach more than 2GB. But you
> probably
> won't see the buffer pool reach 3GB. Maybe, you didn't drive the SQL
> instance
> hard enough for it to use more than what you reported.
> See
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> for an exmaple.
> BTW, how did you get the 2147483647 number?
> Linchi
> "Pieter" wrote:
>> Hi,
>> I have a 32-bit SQL Server 2005 Enterprise Edition with 4GB of memory. I
>> activated the /3GB switch in the boot.ini, but I still can't setthe
>> Maximum
>> server memory any higher than 2147483647. What should I do else? I
>> presume I
>> should be able to set it until 3 gigabytes now?
>>
>> Any help will be really appreciated,
>>
>> Thansk a lot in advance,
>>
>> Pieter
>> This is my boot.ini:
>> [boot loader]
>> timeout=30
>> default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
>> [operating systems]
>> multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003,
>> Standard"
>> /noexecute=optout /fastdetect /3GB
>>

...Contains more than the maximum number of prefixes. The maximum is 3.

SQL Server 2000 8.00.760 (SP3)

I've been working on a test system and the following UDF worked fine.
It runs in the "current" database, and references another database on
the same server called 127-SuperQuote.

CREATE FUNCTION fnGetFormattedAddress(@.WorkID int)

RETURNS varchar(130)

AS

BEGIN

DECLARE

@.Address1 As varchar(50)
@.ReturnAddress As varchar(130)

SELECT
@.Address1 = [127-SuperQuote].dbo.tblCompany.Address1
FROM
[Work] INNER JOIN
[127-SuperQuote].dbo.tblCompany ON [Work].ClientID =
[127-SuperQuote].dbo.tblCompany.CompanyID
WHERE
[Work].WorkID = @.WorkID

IF @.Address1 IS NOT NULL
SET @.ReturnAddress = @.ReturnAddress + @.Address1 + CHAR(13)+ CHAR(10)

RETURN @.ReturnAddress

END

So now the system has gone live and it turns out that the live
"SuperQuote" database is on a different server.

I've linked the server and changed the function as below, but I get an
error both in QA and when checking Syntax in the UDF builder:

The number name 'Zen.SuperQuote.dbo.tblCompany' contains more than the
maximum number of prefixes. The maximum is 3.

CREATE FUNCTION fnGetFormattedAddress(@.WorkID int)

RETURNS varchar(130)

AS

BEGIN

DECLARE

@.Address1 As varchar(50)
@.ReturnAddress As varchar(130)

SELECT
@.Address1 = Zen.SuperQuote.dbo.tblCompany.Address1
FROM
[Work] INNER JOIN
Zen.SuperQuote.dbo.tblCompany ON [Work].ClientID =
Zen.SuperQuote.dbo.tblCompany.CompanyID
WHERE
[Work].WorkID = @.WorkID

IF @.Address1 IS NOT NULL
SET @.ReturnAddress = @.ReturnAddress + @.Address1 + CHAR(13)+ CHAR(10)

RETURN @.ReturnAddress

END

How can I get round this? By the way, I've rather simplified the
function to ease readability. Also, I haven't posted any DDL because I
don't think that's the problem!

Thanks

Edwardteddysnips@.hotmail.com wrote:
[...]

Alias, you dolt!

Sorry if I've wasted anyone's time.

Edward|||Thanks for wasting even more of everyone's time by not indicating your mistake and having this useless thread replicated to dozens of other forums!

From http://www.developmentnow.com/g/95_...ximum-is-3-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com