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?
Yes. The easiest solution is to add more memory.
Jonathan Kehayias came up with a formula to get a starting point for the PLE threshold: (DataCacheSizeInGB/4GB*300)
So if you have, for example, 10 GB of Buffer Cache (in SQLdm: Resources - Memory - Memory Areas - Database), the PLE should stay most of the time above 750.
Another approach would be to look for queries that use a lot of memory. Sometimes a query needs to scan a lot of data because of a missing index. Creating a good index can reduce the memory consumption, because only the needed data can be loaded into the memory. But that's advanced tuning.