June 10, 2014 at 5:15 am
i have 3 instances in a cluster , one of th einstance is using high memory utilisation , how cna we find which instance is using memory .
June 10, 2014 at 6:14 am
It would be best to get good understanding of how memory is used but you can also find out how to troubleshoot the same thing in RedGate ebook: Accidental DBA. Chapter 4 is on troubleshooting memory issues.
You will want to look at the memory related DMVs that will give you a quick check on memory allocations. If you are running three instances you need to configure minimum and maximum memory settings for each instance to limit buffer pool memory.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 10, 2014 at 6:30 am
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply