How is the memory used greater than the SQL Server Express limitation?

sql-server limit sql-server-2014-express
Mark picture Mark · Sep 12, 2015 · Viewed 7.6k times · Source

Microsoft tells me that SQL Server 2014 Express should have Maximum memory utilized (per instance of SQL Server Database Engine) of 1 GB.

Whenever I run this simple script to tell me the Physical Memory In Use I get 4 GB.

SELECT dopm.physical_memory_in_use_kb 
FROM sys.dm_os_process_memory AS dopm;

enter image description here

Here's the version info.

enter image description here

What gives? The server itself has 24 GB of RAM so I'd like SQL Server to use more if possible. I think I'd have start using a different edition of SQL...

Answer

BNK picture BNK · Sep 12, 2015

According to this link

SQL Server 2014 Editions

Express Edition

Express edition is a free version of SQL Server that is limited in its functionality and size. Is limited to one socket with a maximum of four cores for CPU power, 1 GB of memory, and a database size. No larger than 10 GB. If using the reporting features, The maximum memory is raised to 4 GB. Express edition is compatible with all other editions of SQL Server. Express edition has a few different versions that can be downloaded

And according to Features Supported by the Editions of SQL Server 2014, you will find that 4GB RAM limit is at Maximum memory utilized (per instance of Reporting Services) for Express with Advanced Services

Related questions

LIMIT 10..20 in SQL Server

I'm trying to do something like : SELECT * FROM table LIMIT 10,20 or SELECT * FROM table LIMIT 10 OFFSET 10 but using SQL Server The only solution I found looks like overkill: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM …

Read More
Equivalent of LIMIT and OFFSET for SQL Server?

In PostgreSQL there is the Limit and Offset keywords which will allow very easy pagination of result sets. What is the equivalent syntax for SQL Server?

Read More
Hitting the 2100 parameter limit (SQL Server) when using Contains()

from f in CUSTOMERS where depts.Contains(f.DEPT_ID) select f.NAME depts is a list (IEnumerable<int>) of department ids This query works fine until you pass a large list (say around 3000 dept ids) .. then I …

Read More