计算机等级考试辅导：SQLServer(Sql内存不足探索)

　　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.