Score:0

SQL Server Logical Reads increased 10x in past week

bd flag

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!

cn flag
The reads are coming from the application server(s) using the database. I would start there.
GKOS avatar
bd flag
@GregAskew the application is on the same server, is there a way of monitoring the reads to a particular source/process?
cn flag
We don't know what the application is or how to measure its performance or activity.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.