September 14, 2013 at 2:02 pm
Can please provide a script to find the top queries for physical IO usage?
September 15, 2013 at 5:44 am
Not physical IOs, just IO usage. More IO usage, more chance that some will be physical. If you're tuning IO, tune logical IOs, if less data is needed overall, less will have to come from disk.
p.s. If this is related to your previous memory problems, have you identified what is causing Windows to issue low memory alerts? If not, look there, not at SQL's memory usage. Something outside SQL is allocating memory, triggering the OS to issue a low memory alert, causing SQL to reduce its memory usage.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply