Peak Usage information

[Plecebo]

We have information on resource utilization in our DB that we would like to create a chart to summarize.

Basically we have Time out and time in information and would like to see what times of the day the MOST of the resources are in use. Example

TimeIn TimeOut
01:00 03:00
01:15 02:00
13:05 20:20
15:00 22:00

and so on.

What we are hoping for is something like a histogram that will show us when the greatest number of our resources are in use.

Any ideas?

 

[blom0344]

Yes, you need an additional table that stores the hours of the day like:

1  01:00
2  02:00
..  .....
..  .....
24 24:00

and use this table against the time data using a complex join (between) instead of an equi-join.
This will get a resultset where you can perform a count on the hours.


Ties Blom