SQL Express 2005 and 3GB switch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RJ - 30 Apr 2008 17:12 GMT

Hello:
I'm looking for some information regarding the 3 GB switch for SQL Express
2005. I have Windows Storage Server 2003 R2 SP2 and SQL Express 2005. The
server has 4 GB in it. I have a database that is running slow. It takes
about 1.4 GB of RAM and another 1.5 GB in virtual RAM (paged). Is it
possible to use the 3 GB switch to give SQL express more memory? All of this
is on a 32 bit platform. I read somewhere that SQL express can only use 1 GB
of RAM. Any guidance or help would be great.
The best solution here might be to move the database to a full SQL server as
opposed to SQL Express. However, I want to check my options on the 3 GB
switch first.
Many thanks.

Signature

Reply to this Message

Ekrem Önsoy - 30 Apr 2008 21:08 GMT

You can't use more than 1GB of RAM for a SQL Server 2005 Express Edition
instance.

It does not matter you take advantage of 3GB or something else...

Check out the following feature comparison table and pick up a convenient
SQL Server edition for your needs.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Signature

Ekrem Önsoy

> Hello:
> I'm looking for some information regarding the 3 GB switch for SQL Express
[quoted text clipped - 12 lines]
> switch first.
> Many thanks.

Reply to this Message

RJ - 30 Apr 2008 21:28 GMT

Thanks much. That answered my question--moving the database to a full
version of SQL.

Signature

> You can't use more than 1GB of RAM for a SQL Server 2005 Express Edition
> instance.
[quoted text clipped - 21 lines]
> > switch first.
> > Many thanks.

Reply to this Message