如何使用的内存大于SQL Server Express的限制? [英] How is the memory used greater than the SQL Server Express limitation?
问题描述
Microsoft 告诉我, SQL Server 2014 Express的最大使用内存(每个SQL Server数据库引擎实例)为1 GB.
Microsoft tells me that SQL Server 2014 Express should have Maximum memory utilized (per instance of SQL Server Database Engine) of 1 GB.
每当我运行此简单脚本告诉我正在使用的物理内存时,我都会获得4 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;
这是版本信息.
有什么作用?服务器本身具有24 GB的RAM,因此我希望SQL Server尽可能使用更多的内存.我想我已经开始使用其他版本的SQL ...
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...
推荐答案
根据此链接
速成版
Express Edition是SQL Server的免费版本,其功能受到限制. 功能和大小.仅限于一个插座,最大数量为 四个CPU电源核心,1 GB内存和数据库大小.不 大于10 GB. 如果使用报告功能,则最大内存 已提高到4 GB. Express Edition与所有其他版本兼容 版本的SQL Server.速成版有几个不同的版本 可以下载
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
并根据各版本支持的功能SQL Server 2014 中,您会发现 Express with Advanced Services
这篇关于如何使用的内存大于SQL Server Express的限制?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!