Thanks for your reply.

I am logged on to the computer running SQL Server

The other server is Oracle. I use ODBC to get to the Oracle database.

-W R

Thank you.

Step Error Source: Microsoft OLE DB Provider for ODBC Drivers

Step Error Description:[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Step Error code: 80004005

Step Error Help File:

Step Error Help Context ID:0

-W...

datapump task 1 does a select from another server into this server select col1, col2 from table

Thank you.

-W R

I added server trace option under Query Analyzer and the values for "reads" is higher in the production server by 200.

I checked the disk activity in production and there is...

The 2 m/c's have the same hardware. The Nic cards are of the same speed. I did a rdp into both the servers. I run the query on the boxes....

Good questions.

dbcc showcontig on dev

TABLE level scan performed.

- Pages Scanned................................: 4033

- Extents Scanned..............................: 508

- Extent Switches..............................: 507

- Avg. Pages per Extent........................: 7.9

- Scan Density [Best Count:Actual Count].......: 99.41% [505:508]

- Extent...

In the prod box, the time is 11 seconds. On the same database, moved to dev, it is 3 seconds, with non-clustered or clustered. It might be something else that is slowing...

Thank you for your observations.

It is 2000. There was no clustered index. I dropped the index and created a clustered index. Ran dbcc contig.

Results are much better.

TABLE level scan performed.

-...

Thank you for your clear explanation.

Whatever fill factor I use, the results are the same. I am guessing since the table has a million rows, there is nothing much...

Tom,

Thank you for your post. How does the avg. page density being 95% indicate that fill factor of 80% is not being used.

Thanks.

-W R

Thanks. On the money. How do I read more about this. Any pointers?

-W R

I have come to know it is a homegrown tool.

-W R

I used DTS Dynamic Properties to fix this. But, I get an error "MAPI returned an error" when I try to add DTS Mail Task.

Any suggestions?

-W

Thank you. Although, I am unable to add a DTS Email Task due to an error "MAPI returned an error"

-W

Thanks for your comments.

I did run dbcc tracestatus earlier and it shows that the trace is not on. But, I did run dbcctraceon and did not run dbcctraceoff. Only thing...