November 22, 2007 at 2:18 am
I have 16 GB machine on which there are 3 SQL 2005 instances running.
Any ideas how memory should be configured for them?
Additionally anyone trtied to use Windows resource manager to assign CPU limits for each SQL Server process?
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
November 22, 2007 at 2:44 am
Assuming they are all production I would let windows and sql manage memory.
Allen
November 23, 2007 at 9:19 am
Kalen Delaney, in Inside Microsoft SQL Server 2005: The Storage Engine, makes the point that there is no coordinated memory management between instances of SQL Server installed on the same server. Therefore, they are competing with each other for memory resources. Therefore, her recommendation is to use the Min and Max server Memory options in all the SQL Server instances. Otherwise, an instance can become starved for memory. This is in the Note on p. 59 (Chapter 2, right before Observing Memory Internals).
EDIT: Corrected Book Title
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply