20 GIG an hour that a lot of data - how do you know it is 20 GIG or data. That is something you cannot do with a guess....

Can you look at the report in studio standard reports, schema changes history may have this in here for change of sp.

I found out in our test we used named pipes and production tcp/ip after setting test to tcp/ip the program would error same as production timeout values so it has...

Yes i had the exact same error until i loaded the Cumlative 6 updated for SQL 2005 without this it would give the errors below - i could not link...

The one process creates 53 brand new tables with no indexes and every select statement is a table scan does not read any table with a index seek at all.

The...

Looking now - figured out the parameters and what to put in to re run that one single part.

I have to copy the RPC Completed into note pad edit it...

That was just example i not done it on the large process - im getting all my eggs ready.

I have to determine this is true first ? that it is...

i read it wrong i thought that was size next to my value it was a space - wasn't looking clearly enough.

Got size in read/writes but logical reads are not...

From your statistics,

Logical reads are 702,949, 129

Reads are 8130 or about 64 Mb

Writes are about 1.5 Gb

How did you get 129

A lot of data 🙂

I was trying to get it in MG to explain to people how much data they are requesting...blocks will not mean too much to them.

I am...

Just had the same thing happen to me - default timeout for remote connections is 600 seconds 10 minutes. I watched a process run for this amount of time...

Interesting post....CTE's and moved them into table variables can you explain a little more here. Example be nice.

We too just switched from ODBC to SQL OLE. We use the...

Thanks i just changed on servers i keep you posted.

Thanks - im going to reset to 0 so it sets it for ever without timing out incase developers forget to put in their code.

sp_what i look for. ...

This is happening again after 10 minutes

So on server, properties, remote connectoins, remote query - set this to 0 rather than 600 default i increased to 1200 but that...