May 15, 2013 at 10:06 pm
Hi ,
How to monitor memory usage per sql instance and identify any memory-starved instances so additional memory can be allocated in a cluster?
How to check which sql instance requires more memory in a cluster?
How to find how much more memory to add to a sql instance in a cluster?
Thanks
kiran
May 16, 2013 at 5:19 am
There are a lot of different metrics that will tell you about memory. Many of them are available in Performance Monitor. Just go to the memory section, both on the OS and for SQL Server. Also, I wrote this article[/url] to include a few other tricks to get memory utilization hints out of SQL Server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply