Thanks Jeff and SQL Surfer.
I am looking at the DMVs in SQL 2008 to figure out the Waits instead of using PerfMon. I am trying to sample them as well.
Those DMVs tell what was the most utilized resource and what was the bottleneck. I am trying to see how to do the reverse of it. In the sense if I/O was the bottleneck from 10.-11pm then when was it all free and how much bandwidth is available.
I guess need to find out how to do that analysis. If I find anything else/learn I will post it back.
Thanks,
N