Max memory support in SQL Server 2008

Hello,

Are there any extension of max memory support ?

At SQL Server 2005.

Express Edition x86 = 1GB

Workgroup Edition x86 = 3GB

Standard Edition x86 = os limit

Standard Edition x64 = 32TB

Developer Edition x86 = os limit

Developer Edition x64 = 32TB

Enterprise Edition x86, x64 = os limit

Datacenter Edition x86, x64 = os limit

ref: Memory Supported by the Editions of SQL Server 2005
http://msdn2.microsoft.com/en-US/library/ms143685.aspx

Especially , My wish is.

Express Edition x64 (native, non wow) , and 2GB support.

Workgroup Edition x64 (native, non wow), and 8GB support.

For SQL Express the memory limits will remain the same. I don't know about the other editions. The jury is still out on x64 native Express, keep your fingers crossed.

Mike

|||

What I would really like to see is increased database size limits.

|||(akula@.discussions.microsoft.com) writes: > What I would really like to see is increased database size limits. Isn't the limit 4GB? While this not a very big database, I still think it's a reasonable limit for a free product. Yes, it would be nice if SQL Express could handle TB database, but after all MS needs to make money in some way, so that the SQL Server developers can get bread on the table. :-) -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Well the thing about the size limit is that it is simply annoying but easy to bypass. All you have to do is break your large database into several smaller databases and combine the results. I'm not asking for a TB because it wouldn't work well with the memory limitation. But something in the 8GB-32GB range would be helpful especially if you are in a situation where you have a readonly database that is updated quarterly.|||(akula@.discussions.microsoft.com) writes: > Well the thing about the size limit is that it is simply annoying but > easy to bypass. All you have to do is break your large database into > several smaller databases and combine the results. I'm not asking for a > TB because it wouldn't work well with the memory limitation. But > something in the 8GB-32GB range would be helpful especially if you are > in a situation where you have a readonly database that is updated > quarterly. Each time you get annoyed, think of the license fee you paid! :-) Whatever limit there is, there will always be a point where you need to decide: apply a kludge or cough up money for a paid-for edition? -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Max memory support in SQL Server 2008

Hello,

Are there any extension of max memory support ?

At SQL Server 2005.

Express Edition x86 = 1GB

Workgroup Edition x86 = 3GB

Standard Edition x86 = os limit

Standard Edition x64 = 32TB

Developer Edition x86 = os limit

Developer Edition x64 = 32TB

Enterprise Edition x86, x64 = os limit

Datacenter Edition x86, x64 = os limit

ref: Memory Supported by the Editions of SQL Server 2005
http://msdn2.microsoft.com/en-US/library/ms143685.aspx

Especially , My wish is.

Express Edition x64 (native, non wow) , and 2GB support.

Workgroup Edition x64 (native, non wow), and 8GB support.

For SQL Express the memory limits will remain the same. I don't know about the other editions. The jury is still out on x64 native Express, keep your fingers crossed.

Mike

|||

What I would really like to see is increased database size limits.

|||(akula@.discussions.microsoft.com) writes: > What I would really like to see is increased database size limits. Isn't the limit 4GB? While this not a very big database, I still think it's a reasonable limit for a free product. Yes, it would be nice if SQL Express could handle TB database, but after all MS needs to make money in some way, so that the SQL Server developers can get bread on the table. :-) -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Well the thing about the size limit is that it is simply annoying but easy to bypass. All you have to do is break your large database into several smaller databases and combine the results. I'm not asking for a TB because it wouldn't work well with the memory limitation. But something in the 8GB-32GB range would be helpful especially if you are in a situation where you have a readonly database that is updated quarterly.|||(akula@.discussions.microsoft.com) writes: > Well the thing about the size limit is that it is simply annoying but > easy to bypass. All you have to do is break your large database into > several smaller databases and combine the results. I'm not asking for a > TB because it wouldn't work well with the memory limitation. But > something in the 8GB-32GB range would be helpful especially if you are > in a situation where you have a readonly database that is updated > quarterly. Each time you get annoyed, think of the license fee you paid! :-) Whatever limit there is, there will always be a point where you need to decide: apply a kludge or cough up money for a paid-for edition? -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Max memory support in SQL Server 2008

Hello,

Are there any extension of max memory support ?

At SQL Server 2005.

Express Edition x86 = 1GB

Workgroup Edition x86 = 3GB

Standard Edition x86 = os limit

Standard Edition x64 = 32TB

Developer Edition x86 = os limit

Developer Edition x64 = 32TB

Enterprise Edition x86, x64 = os limit

Datacenter Edition x86, x64 = os limit

ref: Memory Supported by the Editions of SQL Server 2005
http://msdn2.microsoft.com/en-US/library/ms143685.aspx

Especially , My wish is.

Express Edition x64 (native, non wow) , and 2GB support.

Workgroup Edition x64 (native, non wow), and 8GB support.

For SQL Express the memory limits will remain the same. I don't know about the other editions. The jury is still out on x64 native Express, keep your fingers crossed.

Mike

|||

What I would really like to see is increased database size limits.

|||(akula@.discussions.microsoft.com) writes: > What I would really like to see is increased database size limits. Isn't the limit 4GB? While this not a very big database, I still think it's a reasonable limit for a free product. Yes, it would be nice if SQL Express could handle TB database, but after all MS needs to make money in some way, so that the SQL Server developers can get bread on the table. :-) -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Well the thing about the size limit is that it is simply annoying but easy to bypass. All you have to do is break your large database into several smaller databases and combine the results. I'm not asking for a TB because it wouldn't work well with the memory limitation. But something in the 8GB-32GB range would be helpful especially if you are in a situation where you have a readonly database that is updated quarterly.

|||(akula@.discussions.microsoft.com) writes: > Well the thing about the size limit is that it is simply annoying but > easy to bypass. All you have to do is break your large database into > several smaller databases and combine the results. I'm not asking for a > TB because it wouldn't work well with the memory limitation. But > something in the 8GB-32GB range would be helpful especially if you are > in a situation where you have a readonly database that is updated > quarterly. Each time you get annoyed, think of the license fee you paid! :-) Whatever limit there is, there will always be a point where you need to decide: apply a kludge or cough up money for a paid-for edition? -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

max memory for SSIS?

If we have a SQL Server 2005 standard edition/Windows 2003 Standard
Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the
maximum size of the memory we could possibly have?
Thank you,
ShivaAnswered in microsoft.public.sqlserver.integrationsvcs
*mike hodgson*
http://sqlnerd.blogspot.com
Shiva wrote:

>If we have a SQL Server 2005 standard edition/Windows 2003 Standard
>Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the
>maximum size of the memory we could possibly have?
>Thank you,
>Shiva
>
>
>

Max memory for SSIS

If we have a SQL Server 2005 standard edition/Windows 2003 Standard Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the maximum size of the memory we could possibly have?

Thank you,

Shiva

SQL 2005 standard doesn't have a maximum memory, you are constrained by your OS and hardware. I think it's around 4 gigs for 2003 standard 32bit.|||

yosonu wrote:

If we have a SQL Server 2005 standard edition/Windows 2003 Standard Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the maximum size of the memory we could possibly have?

Thank you,

Shiva

Is this a question about SSIS? If so, read this: http://blogs.conchango.com/jamiethomson/archive/2005/05/29/1486.aspx

If not, try a different forum.

-Jamie

|||

The 32bit Windows limit is 2GB per process. You can increase this to 3GB, using the boot.ini switch, /3GB.

A classic tip around this is to use several packages and Execute Process Tasks to combine them, but set the out of process option on, as this means each package then gets 2GB as each is it's own process. For small packages this may be detrimental though.

sql

Max memory for SQL 2000 standard edition

Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
Please, can you tell me which is really true. I need to buy right edition of
sql server...
thanks
Hi
SQL Server Standard Edition has a 2GB memory limitation.
Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
not supported)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roman Snajdr" wrote:

> Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> Please, can you tell me which is really true. I need to buy right edition of
> sql server...
> thanks
>
>
|||Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Standard Edition has a 2GB memory limitation.
> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
> not supported)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Roman Snajdr" wrote:
|||No
2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
level.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...[vbcol=seagreen]
> Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
|||In another dialog, you said something about switch /3gb in boot.ini. How does
that works? Also in the same thread of the discussion, another person said
2GB can be used even though the switch is set up. Are there officail
documents available on this issue from MSFT? Thanks.
"Mike Epprecht (SQL MVP)" wrote:

> No
> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
> level.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
>
>
|||Hi Kathy
This is the official word from Microsoft:
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/default...b;en-us;274750
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> In another dialog, you said something about switch /3gb in boot.ini. How
> does
> that works? Also in the same thread of the discussion, another person said
> 2GB can be used even though the switch is set up. Are there officail
> documents available on this issue from MSFT? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>
|||Thanks Kalen. That helps a lot.
"Kalen Delaney" wrote:

> Hi Kathy
> This is the official word from Microsoft:
> How to configure memory for more than 2 GB in SQL Server
> http://support.microsoft.com/default...b;en-us;274750
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
>
>

Max memory for SQL 2000 standard edition

Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
Please, can you tell me which is really true. I need to buy right edition of
sql server...
thanksHi
SQL Server Standard Edition has a 2GB memory limitation.
Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
not supported)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roman Snajdr" wrote:

> Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> Please, can you tell me which is really true. I need to buy right edition
of
> sql server...
> thanks
>
>|||Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Standard Edition has a 2GB memory limitation.
> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB i
s
> not supported)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Roman Snajdr" wrote:
>|||No
2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
level.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...[vbcol=seagreen]
> Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>|||In another dialog, you said something about switch /3gb in boot.ini. How doe
s
that works? Also in the same thread of the discussion, another person said
2GB can be used even though the switch is set up. Are there officail
documents available on this issue from MSFT? Thanks.
"Mike Epprecht (SQL MVP)" wrote:

> No
> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patc
h
> level.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
>
>|||Hi Kathy
This is the official word from Microsoft:
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/defaul...kb;en-us;274750
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> In another dialog, you said something about switch /3gb in boot.ini. How
> does
> that works? Also in the same thread of the discussion, another person said
> 2GB can be used even though the switch is set up. Are there officail
> documents available on this issue from MSFT? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>
>|||Thanks Kalen. That helps a lot.
"Kalen Delaney" wrote:

> Hi Kathy
> This is the official word from Microsoft:
> How to configure memory for more than 2 GB in SQL Server
> http://support.microsoft.com/defaul...kb;en-us;274750
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
>
>

Max memory for SQL 2000 standard edition

Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
Please, can you tell me which is really true. I need to buy right edition of
sql server...
thanksHi
SQL Server Standard Edition has a 2GB memory limitation.
Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
not supported)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roman Snajdr" wrote:
> Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> Please, can you tell me which is really true. I need to buy right edition of
> sql server...
> thanks
>
>|||Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server Standard Edition has a 2GB memory limitation.
> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
> not supported)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Roman Snajdr" wrote:
> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> > Please, can you tell me which is really true. I need to buy right edition of
> > sql server...
> > thanks
> >
> >
> >|||No
2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
level.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
> Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> SQL Server Standard Edition has a 2GB memory limitation.
>> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB
>> is
>> not supported)
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Roman Snajdr" wrote:
>> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
>> > GB.
>> > Please, can you tell me which is really true. I need to buy right
>> > edition of
>> > sql server...
>> > thanks
>> >
>> >
>> >|||In another dialog, you said something about switch /3gb in boot.ini. How does
that works? Also in the same thread of the discussion, another person said
2GB can be used even though the switch is set up. Are there officail
documents available on this issue from MSFT? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> No
> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
> level.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
> > Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> SQL Server Standard Edition has a 2GB memory limitation.
> >> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB
> >> is
> >> not supported)
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Roman Snajdr" wrote:
> >>
> >> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
> >> > GB.
> >> > Please, can you tell me which is really true. I need to buy right
> >> > edition of
> >> > sql server...
> >> > thanks
> >> >
> >> >
> >> >
>
>|||Hi Kathy
This is the official word from Microsoft:
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> In another dialog, you said something about switch /3gb in boot.ini. How
> does
> that works? Also in the same thread of the discussion, another person said
> 2GB can be used even though the switch is set up. Are there officail
> documents available on this issue from MSFT? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>> No
>> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the
>> patch
>> level.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
>> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
>> > Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
>> >
>> > "Mike Epprecht (SQL MVP)" wrote:
>> >
>> >> Hi
>> >>
>> >> SQL Server Standard Edition has a 2GB memory limitation.
>> >> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but
>> >> /3GB
>> >> is
>> >> not supported)
>> >>
>> >> Regards
>> >> --
>> >> Mike Epprecht, Microsoft SQL Server MVP
>> >> Zurich, Switzerland
>> >>
>> >> MVP Program: http://www.microsoft.com/mvp
>> >>
>> >> Blog: http://www.msmvps.com/epprecht/
>> >>
>> >>
>> >>
>> >> "Roman Snajdr" wrote:
>> >>
>> >> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
>> >> > GB.
>> >> > Please, can you tell me which is really true. I need to buy right
>> >> > edition of
>> >> > sql server...
>> >> > thanks
>> >> >
>> >> >
>> >> >
>>
>|||Thanks Kalen. That helps a lot.
"Kalen Delaney" wrote:
> Hi Kathy
> This is the official word from Microsoft:
> How to configure memory for more than 2 GB in SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> > In another dialog, you said something about switch /3gb in boot.ini. How
> > does
> > that works? Also in the same thread of the discussion, another person said
> > 2GB can be used even though the switch is set up. Are there officail
> > documents available on this issue from MSFT? Thanks.
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> No
> >>
> >> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the
> >> patch
> >> level.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> >> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
> >> > Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> >> >
> >> > "Mike Epprecht (SQL MVP)" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> SQL Server Standard Edition has a 2GB memory limitation.
> >> >> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but
> >> >> /3GB
> >> >> is
> >> >> not supported)
> >> >>
> >> >> Regards
> >> >> --
> >> >> Mike Epprecht, Microsoft SQL Server MVP
> >> >> Zurich, Switzerland
> >> >>
> >> >> MVP Program: http://www.microsoft.com/mvp
> >> >>
> >> >> Blog: http://www.msmvps.com/epprecht/
> >> >>
> >> >>
> >> >>
> >> >> "Roman Snajdr" wrote:
> >> >>
> >> >> > Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4
> >> >> > GB.
> >> >> > Please, can you tell me which is really true. I need to buy right
> >> >> > edition of
> >> >> > sql server...
> >> >> > thanks
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
> >
>
>

Max Memory for each standard instance

If I have multiple standard instances installed, can I assign fixed memory to
each instance?
Like 2GB of fixed memory for each Standard instance.
In other words when microsoft says that the Max mem for standard edition is
2GB, do they mean for each standard instance, or for standard multiple
instances?
That's for each instance.
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D04974BB-B43E-495A-A86A-B5DABB498A23@.microsoft.com...
> If I have multiple standard instances installed, can I assign fixed memory
> to
> each instance?
> Like 2GB of fixed memory for each Standard instance.
> In other words when microsoft says that the Max mem for standard edition
> is
> 2GB, do they mean for each standard instance, or for standard multiple
> instances?
>

Max Memory for each standard instance

If I have multiple standard instances installed, can I assign fixed memory to
each instance?
Like 2GB of fixed memory for each Standard instance.
In other words when microsoft says that the Max mem for standard edition is
2GB, do they mean for each standard instance, or for standard multiple
instances?That's for each instance.
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D04974BB-B43E-495A-A86A-B5DABB498A23@.microsoft.com...
> If I have multiple standard instances installed, can I assign fixed memory
> to
> each instance?
> Like 2GB of fixed memory for each Standard instance.
> In other words when microsoft says that the Max mem for standard edition
> is
> 2GB, do they mean for each standard instance, or for standard multiple
> instances?
>sql

Max Memory for each standard instance

If I have multiple standard instances installed, can I assign fixed memory t
o
each instance?
Like 2GB of fixed memory for each Standard instance.
In other words when microsoft says that the Max mem for standard edition is
2GB, do they mean for each standard instance, or for standard multiple
instances?That's for each instance.
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D04974BB-B43E-495A-A86A-B5DABB498A23@.microsoft.com...
> If I have multiple standard instances installed, can I assign fixed memory
> to
> each instance?
> Like 2GB of fixed memory for each Standard instance.
> In other words when microsoft says that the Max mem for standard edition
> is
> 2GB, do they mean for each standard instance, or for standard multiple
> instances?
>

max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AW
E
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM
.
http://www.microsoft.com/windowsser...es.msp
x
--
MG
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsser...es.msp
x
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/d...br />
8dbn.asp
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AWE
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM.
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

MasterDB

After I restore the Master db from server A into Server B
The SQL 2K (Standard edition)service does not want to
start.
Server A and B have the same SQL version and build, SP.
what seems wrong?got any error?
"sdl" <anonymous@.discussions.microsoft.com> wrote in message
news:63cd01c40154$06b25e50$a301280a@.phx.gbl...
> After I restore the Master db from server A into Server B
> The SQL 2K (Standard edition)service does not want to
> start.
> Server A and B have the same SQL version and build, SP.
> what seems wrong?
>|||Hi,
Can you please attach the SQL server error log, file will be in sql server
program directory\log folder.
The reasson for this problem might be ,
1. The physical files for system databases (Model, TEMPDB, MSDB) might be in
diffrent location for the SERVER A. so
after restore in Server B during start up SQL Server will not be able to get
the files and resulted in failure.
Tahnks
Hari
MCDBA
"sdl" <anonymous@.discussions.microsoft.com> wrote in message
news:63cd01c40154$06b25e50$a301280a@.phx.gbl...
> After I restore the Master db from server A into Server B
> The SQL 2K (Standard edition)service does not want to
> start.
> Server A and B have the same SQL version and build, SP.
> what seems wrong?
>

MasterDB

After I restore the Master db from server A into Server B
The SQL 2K (Standard edition)service does not want to
start.
Server A and B have the same SQL version and build, SP.
what seems wrong?got any error?
"sdl" <anonymous@.discussions.microsoft.com> wrote in message
news:63cd01c40154$06b25e50$a301280a@.phx.gbl...
> After I restore the Master db from server A into Server B
> The SQL 2K (Standard edition)service does not want to
> start.
> Server A and B have the same SQL version and build, SP.
> what seems wrong?
>|||Hi,
Can you please attach the SQL server error log, file will be in sql server
program directory\log folder.
The reasson for this problem might be ,
1. The physical files for system databases (Model, TEMPDB, MSDB) might be in
diffrent location for the SERVER A. so
after restore in Server B during start up SQL Server will not be able to get
the files and resulted in failure.
Tahnks
Hari
MCDBA
"sdl" <anonymous@.discussions.microsoft.com> wrote in message
news:63cd01c40154$06b25e50$a301280a@.phx.gbl...
> After I restore the Master db from server A into Server B
> The SQL 2K (Standard edition)service does not want to
> start.
> Server A and B have the same SQL version and build, SP.
> what seems wrong?
>