My last suggestion is that with Extended Events you can capture wait statistics solely for a particular spid\session - might it be worth you capturing this information for the ETL...

No one here will be able to tell you what size your tempdb should be, if you have an ample amount of space on your drive or even better a...

Just to confirm that I realized from your original post that it is the same instance and the times differ depending on what node (from the cluster) the instance is...

Hi you mentioned the 'bad run times' having a different number of parallelism, is ti worth you controlling the parallelism with MAXDOP for the ETL process (if possible) and running...

Read this article, I have the same dilemma (my boss calls it an opportunity) and will be looking to partition the 'log' tables by date, once partitioned then you can...

Just to give you some background clustering works on a heartbeat which is configured in Failover Cluster Manager for each each clustered resource or cluster goup.

What were you collecting in...

For SQL 2005 you have the default trace which tracks DDL changes.

I guess our old friend MS Profiler could be used with server side traces...

You could use SQL Audit or Extended Events to track your changes.

Can you check which SQL Process ID is consuming all of the CPU, or if it is a combination of two or all three...?

Just out of curiousity did you upgrade...

Hi,

Just to confirm the job always fails when re-building the same index...? How big is the index and how much memory do you have allocated to your server \...

Hi there, is it possible for you to give an example of the jobs you have written - much appreciated.

In SQL 2005 u need ALTER TABLE permissions to be able to perform the BCP.  Check in BOL.

Def have to agree with you on that one!!

Will this not build a new log file - when doing so it will try to set the size of the logfile to the size of the original logifile...?

Can he not use, (cant access BOL at the mo), sp_restoresinglefileonly or sp_attachesinglefileonly something like that - it will allow you to attach the database without having the log file...