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...

Thanks Jeff for the reply.

I agree I can do Partitioned Views. Just some more background why I couldn't do it now.

First want to clear something up. I just inherited...

One option is to setup a subscription for the report and see how long that takes to run. This will reduce some latency/rendering issues.

Also can you check the execution plan...

Anybody have performance details based on newer version of SQL Server, I heard that SQL 2012 and 2014 has better compression now that is comporable to LiteSpeed.

I suppose could take...