SQL Server 2005 standard edition

Question

Post reply

SQL Server 2005 standard edition

williamminor

SSCommitted

Points: 1664
More actions
June 25, 2008 at 7:55 am

#126102

I have a quick question about sql versions. When did SQL standard edition start supporting the operating maximum for ram. Has this always been the case. I'm sure I remember reading that it was 2 GB or 3 GB if the switch was turned on...
-WM
DBA

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

2005.

SQL 2000 standard supported max 2 GB, regardless of the setting of the /3GB switch or AWE

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

williamminor SSCommitted Points: 1664 More actions · Answer 2

Sorry about the confusion. I'm talking about SQL 2005 standard edition

Thanks

-WM

SQLshifu SSC Eights! Points: 953 More actions · Answer 3

Features:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Pricing

http://www.microsoft.com/sql/howtobuy/editionspricing.mspx

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 4

Hi,

For SQL Server 2005 standard edition there is no limit.

Check the following link http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/[/url]

Regards

williamminor SSCommitted Points: 1664 More actions · Answer 5

Thanks for the information. I just got confused. We only have Win 2003 sever standard which only allows 4 GB max. That's where my limitation was coming from...

Thanks

again

-WM

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 6

Just For info

Anyway, to summarise; Windows 2003 R2 Standard Server x32 has a maximum of 4GB of RAM, Windows 2003 R2 Standard Server x64 has a maxium of 32GB of RAM.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/22/windows-2003-r2-standard-server-sql-server-2005-standard-memory-limits.aspx