November 1, 2015 at 1:17 am
Good morning Everyone,
I have 4 instances on a box. How can i find which instance is causing memory pressure? Also, how to find which instance is consuming more memory? Thanks a lot
November 1, 2015 at 2:39 am
coolchaitu (11/1/2015)
Good morning Everyone,I have 4 instances on a box. How can i find which instance is causing memory pressure? Also, how to find which instance is consuming more memory? Thanks a lot
What are the box's specs and instances' configurations?
😎
November 7, 2015 at 4:40 pm
If the sqlservr.exe startup accounts have not been given the Lock Pages In Memory right, you can use Perform's Processes\sqlservr Private Bytes and ID counters. The Windows' process ID is identified in SQL Server's errorlog, during startup.
Or whether or not the sqlservr.exe startup accounts have Lock Pages In Memory, you can use SQL Server's Buffer Manager Total Server Memory counter.
However, unless you like playing "whack a mole" with memory consumption, you should be capping max server memory for each of the 4 instances, so that in total they do not exceed the physical memory on the box (after leaving some memory for the OS and other significant memory consumers, such as SSRS, SSIS, etc).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply