In short, I would like to understand the difference between physical and logical reads/writes in a database. When (which threshold) should I be worried about them? Is this post an accurate description? (Even in that case, I am still a bit unclear as to what can be considered high reads or writes).
I am doing level 2 support at this moment and the drive where our production database resides is experiencing severe performance problems:
I ran 2 of Glenn Berry's diagnostic information queries to view the top 10 stored procedures in terms of total logical writes and average I/O and got the following back:
My task is to identify the stored procedures that may be causing the low %idle time so our product team can review the code.