simon_s (3/7/2014)
Do you have a ballpark youd start at for total LIO per server or for a level of percentage increase where youd start to think ouchie
Depends on the server, the application it supports, the data growth, etc.
There's no value which makes me say something's a problem. It's all in relation to normal for that server and what all the other queries are doing.
If, for example there's one query doing 1000000 reads per execution, it executes frequently and the next highest query is 10000, then I'm going to look at the first one and see what it's doing and whether it can be tuned. If the first query ran once a month or if more than half of the queries on the server did around the same number of reads I might not even notice it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability