SQL Server maximum Server Memory

Question

SQL Server maximum Server Memory

IT researcher

SSCertifiable

Points: 7567
More actions
February 25, 2021 at 9:53 am

#3849996

I am using SQL Server 2008 R2 Express edition. I have already set Maximum Server memory to 2Gb.
Is there any benefit if I Change it from 2Gb to 3Gb?

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

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

Ken McKelvey SSCoach Points: 18765 More actions · Answer 1

That rather depends on the amount of memory your machine has and what else is running.

Incidentally SQL 2008 R2 is out of extended support so you may want to upgrade to a more recent version to get security patches.

frederico_fonseca SSCoach Points: 16005 More actions · Answer 2

no benefit - Express will use a maximum of 1 GB for database engine

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645993(v=sql.105)?redirectedfrom=MSDN

ScottPletcher SSC Guru Points: 100942 More actions · Answer 3

Get the Developer Edition, that would allow you to use more RAM and give you many other added capabilities as well.

SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 4

Just be careful what you use the Developers Edition for. If the databases on your SQL Express system are production databases in any way, shape, or form, it's a flagrant license violation to use the Developers Edition for such a thing.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 5

Jeff Moden wrote:

Just be careful what you use the Developers Edition for. If the databases on your SQL Express system are production databases in any way, shape, or form, it's a flagrant license violation to use the Developers Edition for such a thing.

This. So very much this.

The Developers Edition is excellent and a useful tool... for development and testing. It can't be used in any kind of production capacity.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning