SQL Server Logical Reads increased 10x in past week

Asked Nov 18 '22 at 11:32

Active Nov 18 '22 at 11:32

Viewed 25 times

I'm not an SQL DBA by any serious standard but I am trying to figure out why the logical reads have gone bonkers on a DB I have for a line of business app. the image below shows a 10 x increase in logical reads? what could be causing that? Feel free to ask for any other info, as far as I can tell server performance metrics are fine CPU/Ram etc The area highlighted in green is where I would like to get back to, as you can see the execution count has not really changed :-/

SQL Query Tool - Overall Resource Consumption

Many thanks in advance!

asked Nov 18 '22 at 11:32

GKOS

The reads are coming from the application server(s) using the database. I would start there. – Greg Askew Nov 18 '22 at 12:30
@GregAskew the application is on the same server, is there a way of monitoring the reads to a particular source/process? – GKOS Nov 18 '22 at 14:36
We don't know what the application is or how to measure its performance or activity. – Greg Askew Nov 18 '22 at 15:13

SQL Server Logical Reads increased 10x in past week

0 Answers0