Thanks for the advice Kevin.

I'm spending a lot of time reading around the subject to develop my understanding. I've built a test database too which has proved to be...

Will do.

How do I delete posts?

Hi Gail,

One portion of the overnight run actually doubled in length from 10 minutes to 20 minutes. Based upon what you have said I'm starting to think that maybe...

Hi Gail,

One portion of the overnight run actually doubled in length from 10 minutes to 20 minutes. Based upon what you have said I'm starting to think that maybe...

Hi Gail,

One portion of the overnight run actually doubled in length from 10 minutes to 20 minutes. Based upon what you have said I'm starting to think that maybe...

Funny thing is that one part of the overnight activity actually increased from 10 minutes to 20 minutes despite the overall saving.

I'm starting to think that maybe one of...

Will do Gail.

Thanks again.

I'll upload all of the information as soon as I can work out how to do it :O)

Cossy

Hi Lutz,

Ditto my comments above.

As soon as I can work out a way of extracting those queries and obtaining the execution plans Ill upload the data.

Thanks again....

Hi Gail,

I've just read the URL and its going to take a while to get the info.

Its a stored procedure that runs several large queries with variables etc....

Hi Gail,

The DTA recommendations have reduced the elapsed time of this overnight activity from 2 hours 30 minutes to 1 hour 15 minutes.

I will be checking the impact...

Hi Lutz,

Thanks for the reply.

You are right.

I dug a little deeper in to the stored procedure and there are five huge queries that relate to three...