How is the memory used greater than the SQL Server

问题:

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;

Here's the version info.

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...

回答1:

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