Improve the performance of the query\report ie add indexes\rewrite etc. Look into the execution plan of the problematic query.

Are the backups being taken locally?

Are there any other services taking up resources while the backup is running. ie. SSAS,SSIS

Do you have a dedicated drive for backups.

Is it physical or...

Got the task of moving changes from one DB???

What exactly are you moving within the DB. What changes??

To which DB?

I'm a big fan of Idera

You probably have very slow running queries in your repository database. I would look to performance tune rather than look to change ISOLATION Levels which I don’t believe will help...

oK

Is there anything updating\Inserting or deleting from the db at the same time

Wow thanks for all the replies. Very helpful.

I'll chew through it all tomorrow.

Hi All

I did state in my original post that I agree it should have a clustered index.

My question is that changing a table which has multiple indexes and has many...

Not me 3rd Party. The table is a Heap it is badly designed with far too many columns and serving many different purposes.

They believe it will improve performance. My...

Thanks

Thanks

Thanks Charles,

Yes the password was not kept. So I cannot use the SSISDB on the secondary node after failover.

Thanks Jason,

I'm leaning towards doing that.

@SQLFRNDZ

Nice one help me out, The SP2 failure was bugging the CR@P out of me.