I apologize for not following the forum netiquette. I will post DDL in the future asks.

As far as DML or design is concerned, this is the university assignment and not...

Hi Jonathan,

This worked. Thanks a ton.

Hi Romel,

Your query gave the desired results. But they want this result in a single query. Thank you.

Hi Jonathan,

This does not give the desired results.

This is the output from whoisActive for all the sessions with OLEDB wait

sql_text: INSERT INTO @P

EXEC (@SQL) AT linkedservername

I will try getting the driver updated.

I also noted wait type OLEDB just before crash.

wait_info

(596ms)OLEDB

(769ms)OLEDB

(926ms)OLEDB

(183ms)OLEDB

(848ms)OLEDB

(1977ms)OLEDB

(83ms)OLEDB

(1324ms)OLEDB

(274ms)OLEDB

(623ms)OLEDB

I am guessing its the cwbodbc driver which caused the crash.

Sure thanks. I will do that.

SQL Server Memory : 220 GB

Total memory: 244 GB

Apart from SQL Server there is C# service which runs a bunch of Stored procedures and gets the data from AS400.

There is...

Thanks Gail & Grant for the reply. I've been asked to raise a case with Microsoft to identify the root cause.

Thanks,

San

Sorry about that. Was in a rush.

SQL Server 2008 R2 Enterprise Edition SP2

32 processors

MaxDOP = 8

Cost threshold of parallelism = 5

Max Server memory: 52320

2 node active passive cluster

I want...

Thanks Grant

If I combine the data from 2 trace files and load them into a table then log gets filled because there are millions of records. We need to keep atleast...