threads are hanging during inserting the records into Sql server 2

threads are hanging during inserting the records into Sql server 2

Post by VmVlcn » Thu, 19 Oct 2006 21:05:02


Hi

I am trying to insert the data using my process into the SQL Server.

During testing we are noticing that if multiple threads are used, the calls
from those thread to sql native client hangs. This is intermittent but on an
average for every 7 10 runs for the same data-set I can get it to hang. For
single thread so we haven faced this issue. The thread are independent and
do not share any resource between them. They get the data to load using IO
Completion port. The data source and session is opened when the thread is
initialized. Breaking into de *** , I can see from the stack trace that the
calls into sql native client dll have not returned.



Note that the same data-set passes through successfully when used against
oracle. We do this to ensure that it is not some thing in our code that has
changed during the migration. Let me know how I can go about trouble-shooting
and if there is anything that you need from my end.


Regards
Veeru
 
 
 

threads are hanging during inserting the records into Sql server 2

Post by VmVlcn » Thu, 19 Oct 2006 21:08:02

I would like to one more point that is CPU uasage is more that 90% most of
the times and also reaching 100%