November 6, 2002 at 9:29 am
I have a server that has 6 GBS of memory on it running two instances. Is there a way to tell exactly how much each instance of SQL Server is utilizing out of the 6 GBS.
November 6, 2002 at 9:44 am
Have you enabled AWE? With more than 2GB, and when you enable AWE, you need to set the min and max for each instance. Otherwise, they will be sharing the 2GB base space.
You can do this in the server properties in Enterprise Manager.
You can tell from task manager or perfmon (SQL Server Buffer Manager:Total Server Memory)
Steve Jones
November 6, 2002 at 12:36 pm
Look at the Memory Manager object for each instance in Performance Monitor (perfmon). The Total Server Memory (KB) counter should tell you how much memory is being used. These numbers may not exactly match Task Manager, but they give you an idea of how much memory is being used by each instance.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
November 6, 2002 at 1:00 pm
if you use AWE remember that SQL Server will hold on to the setting in MAX SERVER MEMORY for each Instance.
Not dynamic memory allocation here.
November 6, 2002 at 2:47 pm
Thanks for the help!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply