cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

How to find queries during peak hours vs non peak

Hi!

I was wondering if there is a way to look at queries (specifically ones that cause long waits) and compare their times during peak hours to non-peak hours? Every time I try to look at historical charts the charts don't load and I'm not sure if I can separate the times there.

5 Replies
Product Manager
Product Manager

Troy,

Thanks for the question.  The historical charts will allow you to see how the query is behaving over time for each day, and what kinds of waits in encountering. It doesn't allow you to drill into a day, but at the bottom is has the typical day, which shows you how much wait time this query has hour by hour.

Is that page not coming up for any query, or just some?

Ex: Historical chart.

pastedImage_1.png

0 Kudos

Hi bmrad,

I am unable to see any of the Top waits, Average waits, or typical day with version 11.0.378 for any query. Our situation is just trying to find justification for purchasing a new server and we need some data.

0 Kudos
Product Manager
Product Manager

Can you post a screenshot of what you see for your query?

0 Kudos

Ahhh, OK so IE11 doesn't display it for some reason but Chrome does. So I guess my next question is if we move the VM to a new server will we still have all this historical data to compare?

DPA historical chart screenshot.PNG

0 Kudos
Product Manager
Product Manager

If you can keep the repo, you can change out DPA servers and keep your history.

See Move DPA to another server - SolarWinds Worldwide, LLC. Help and Support

0 Kudos