December 7, 2006 at 4:43 am
Hi folks,
I have written an application which parses a set of XML files and stores in the database. After a cycle, the corresponding table will be having some milions of rows. For each cycle, I am starting the transaction and committing the transaction for each file processing. If at all, any error occurs in the middle of processing of a file, then the transaction will be rolledback and failed error details will be logged into another table of the database. All this functionality is working fine if I run a single instance of application. But if run multiple instances of the same application, sometimes in the middle of the processing some of the instances are getting hanged. When I dig into the reason, I found that process is hanged during the execution of the stored procedure, in that a couple of INSERTS and UPDATES are there. These tables are heavy data tables containing around 5 to 6 million rows. If I look into the enterprise manager, there are no locks being found and all the processes are in "Awaiting command" status.
I am unable to find out the reason for this. Any help is appreciated regd. this.
This is my server configuration:
Intel(R) Xeon(R) CPU 5110 @ 1.64GHz 2GB RAM 272GB HDD MS Server 2003.
Regards,
Jitu.
December 7, 2006 at 8:23 am
Run sp_lock to see which objects are locked. You got to be very careful when manipulating large tables. I mean check your queries carefully before executing them.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply