2

I have the following historical wait report for my SQL server.

enter image description here

I have noticed that Wait Category Tran Log IO is consuming 27.09% of percentage time followed by Query Store which takes 24.34%. I want to know if this distribution is normal or should I take any adequate steps to improve the performance of my server.

Improve this question

1 Answer 1

Reset to default
4

compared to what?

This report stinks for a couple reasons:

  • It doesn't tell you how long the server has been up
  • It doesn't tell you how long each wait lasted on average

I wouldn't use this to try to figure anything out, because:

  • The percentages are only compared to all other collected waits
  • Something could be happening a lot, but also happening very quickly
  • Something could be happening infrequently, but lasting a long time

Waits are typically something you need to track and trend over time to better understand when they're happening and what their impact is on the workload (if any). Remember that waits will happen even when there's nothing bad happening. They don't indicate an issue merely by existing.

If this is a server you care about, find a monitoring tool that meets your observational requirements.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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