Sayed thanx

2 nodes.

Is distance really important? Ik could have a long distance with a short RTT and a short distance with a long RTT. I know this doesn't sound logical but...

Hi Suresh,

Thanx for the quick reply.

Is the new client utility installed as a default OS component like the 2000 version or does is need a seperate client installation? If this...

By the way,

Also I should get rid of the "TOP 100 percent" if you don't use it.

Kind regards,

Dave

Hi There,

Changing the query to explicit INNER JOINs with ON statements might prevent improper execution plan.

In your current query, their might be a possibility that SQL first joins all tables...

Hi there,

I have the same issue.

Running the SSIS package manually works fine. Running the same package based on a schedule, the same error happens.

I fought it could have something to...

fyi

As far as I have tested it looks like only the source metadata is relevant.

Kind regards,

Dave

Hi Frank,

You mention the following:

"SSIS calculates how many rows to fit in the buffer based on the estimated row size. And the estimate is based on the metadata that you...

Regarding I/O:

I already used PAL to get an impression of LAN (SAN) performance. After tweaking a little, discovered issues regarding SAN performance were solved. As for as I know throughput,...

Maxdop unfortunately did not give any major improvements.

Regarding the validity of the test;I agree. However. Before the issues started, the queries were much, much faster then those 2 minutes....

So stopping...

The query takes a long time to execute. So after two minutes I stop the query to see how many records are retrieved. The more records retrieved in those two...