sql2005 报告内存不足,我们的服务器 16G 内存,根据以往经验,这个够了,但是为什么还报告这个错误?
这台服务器连接的Server 比较多,据推断可能与连接的Server 有关系;
网上看到sql内存大约分为三个部分:
Buffer Pool(最重要);
MemToLeave:used for external components such as Linked Servers, OLE DB Providers, Extended Stored Procedures, OLE Automation objects (COM components);
AWE;
The size of the MemToLeave region can be adjusted using the -g command line parameter. The total memory required for the worker thread stacks cannot be changed without changing the max worker threads sp_configure value or modifying the default thread stack size by hacking the SQL Server executable, which you should definitely not do. However, you can increase or decrease the 256MB set aside for allocations outside of the BPool by passing a different value for the -g parameter. This parameter can be handy in situations where you have a lot of linked server queries, in-process COM objects, or other memory consumers contending for space in the MemToLeave region. By making it larger, you give them a bigger sandbox in which to play. Conversely, shrinking it can provide more virtual memory space for the BPool and may improve performance in some situations.
第一考试网站提示: 本机上启动sqlserver,启动成功。

第一考试网友情提示:如果您遇到任何疑问,请登录第一考试网考试辅导频道或添加qq:,第一考试网以“为考友服务”为宗旨,秉承“快乐学习,轻松考试!”的理念,旨在为广大考友打造一个良好、温馨的学习与交流平台,欢迎持续关注。以上是小编为大家推荐的《计算机等级考试辅导:SQLServer(Sql内存不足探索)》相关信息。
编辑推荐