I am running IDERA SQLdm 10.0.2.2261 on 1 instance of SQL 2014 using VMWare with 6 core.
I am noticing times when there are high Batch requests per second over 500 throughout the day. Does this imply I might need to increase memory?
The number of batch requests per second is just the amount of work SQL Server has to do. It is no indication of memory pressure.
An indication of memory pressure is a continuous low page life expectancy combined with a high physical read value.
Thanks Dan. What would need to happen to increase the page life expectancy to decrease memory pressure? Do I need more memory?