Batch Requests per second

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?

Thank you.

Jon Lellelid

JLellelid@sno-ilse.org

Parents
No Data
Reply
  • 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.

Children