Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What does the green and blue indicate from the below scrteenshots of disk activity on SQL Server database server?


enter image description here

share|improve this question

closed as off-topic by Max Vernon, RolandoMySQLDBA, Mark Storey-Smith, Paul White, bluefeet Nov 30 '13 at 12:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – RolandoMySQLDBA, Paul White
If this question can be reworded to fit the rules in the help center, please edit the question.

This question appears to be off-topic because it is about Windows resource monitor. – Max Vernon Nov 28 '13 at 20:31

This seems to be related to your earlier question about High Disk IO. Have you looked at other items to see what is going on as suggested in my answer there? Wait Stats, Query Information, Etc? I think you should look at everything. And in this case it still looks like your disk queue length on that drive at that one time isn't bad. You need to really look at your IO Latency as I mentioned in that answer. It looks to me like you are still hunting around for an IO issue, but should look at the full set of information as I mention in the answer there to really help you out.

But the question here: This screen is in the Resource Monitor, and the blue line refers to the active time of the drive. So in this case you had a quick spike of higher activity on the K drive and mostly the drive wasn't very active.

share|improve this answer
Thanks! And what does the green represent? Seems to be high a lot of the time. – k09 Nov 29 '13 at 9:18

Not the answer you're looking for? Browse other questions tagged or ask your own question.