After a suggestion from a previous poster, I have changed the process to drop all the indexes exept for the clustered index and then perform the insert statement, after that...

I've just had a look at my original post and the version we are running is The SQL Server 2000 version is :- 8.00.2187 SP4 Standard Edition. So I assume...

Hi ALZBA, I'm not sure if I have added that... Should I if I haven't?

I'll post that when I get back to the site on Monday...

Hi Matt,

I already have a few tables that monitor each process that is running.

AUDIT_JOB - Which shows the overall job start/end time (13 hours)

AUDIT_TASK - Shows each task start/end...

Hi Matt,

To answer your questions:-

I am only using DTS to initially transfer the data from Oracle 9.2 to SQL Server. After that all other processes are performed using stored procedures...

Hi Bob,

No foreign keys or triggers.

Pete

Hi Gail,

Thanks... I can't do the stat check today, as I am on a different site, I should be there on Monday.

When I performed statistics last time, disk queue length...

Hi Gail,

Thanks for the clarification... But looking at the simple example in BOL

USE pubs

IF EXISTS (SELECT name FROM sysobjects

WHERE name = 'employee_insupd' AND...

Sergiy I don't mind constructive criticism, but why bother posting if you can’t help me with the issue I have posted

Do explain why you think a trigger is good when...

Thanks Matt, mostly these tables don't have clustered indexes, just a few.

BTW - The 100 Gb refers to the total size of the database, not a specific table. The largest...

Thanks Bob,

It has been slowly increasing in time, although recently it increased from running in 10 hours to 13 hours (a year ago it was running in 6 hours).

Trigger...

Thanks ALZDBA Not sure what the benefits of sorting the data by the fields in the clustered index, because if the clustered index is not dropped the data will be...

Most of the tables don't have clustered indexes as they are interim tables and are only used for the ETL processing. The ones that do have clustered indexes the indexes...

HI Antares686,

Thanks for your post.... I have run performance monitoring during the load CPU does not get maxed out,

although the disk queue length are fairly large (50-146). The machine...