Thanks all for your help thus far, troubleshooting the performance issues is one thing...and I get that.

Still have the questions regarding

1. Would it have better performance putting the transaction...

I agree. I am poking around. If I was to try to find performance bottlenecks, where would I start?

The main performance issue I can see is when running large...

So, in General, are you saying you should or shouldn't put the transaction log on a separate physical disk?

Good points.

As for bottleneck, I don't know for sure that is the bottleneck. Months back I remember running performance

monitor and watched the counters. According to a few articles I...

Update. Problem solved. We needed to update the service packs for Crystal reports. Recreate and save the query and it works. Thanks all for the help.

Adding

Option Robust Plan to the end of the query did not work

So, should I use the "Robust Plan"? If so, is this just something you add to the query..

like

XXXXXXXXX

XXXXXXXXXXXXX

XXXXXXXXX

OPTION (ROBUST PLAN)

The same report worked prior to the upgrade. Why am I just now getting this error?

Also, the only other difference is..I am running SQL 2005 SP4 instead of SP2....

Sorry. I am very new to SQL. What do you mean compatibility level?

Thanks for all your help.

I shrank the tlog manually. I thought I needed to so the performance would improve. But, it sounds like your saying

you should not need to shrink the tlog. Is that...

What happens if I preset the transaction log to 50gb and I reach that limit?

Last month I did a "Shrink DB" command. The transaction log was up to about 11gb....