-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: kai_275
Message 1 in Discussion
Hello All,
We are facing SQL Server related problem in IMD application. Here is the
scenario:<o:p> </o:p>
We have a windows application (24x7) that has timer running on the form. The
timer interval is set at 30 seconds. On every timer tick, a method is called that
executes a stored procedure. On execution of the stored procedure, certain tables are
updated, that causes triggers on the tables to run. These triggers are in turn
executing a stored procedure and so on resulting in a lot of database activity.
<o:p></o:p>
We do not have control on the database (tables, triggers etc cannot be
modified by us). <o:p></o:p>
Also, another C++ application is running in background that constantly pumps
data into the database. This application updates many tables at a time in a
transaction (and hence holds locks on the database tables).<o:p></o:p>
Issue 1: After running a single instance of Windows application for about 8-9 hours,
the following error was received:<o:p></o:p>
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior
to completion of the operation or the server is not responding.<o:p></o:p>
<o:p></o:p>
Issue 2: After running multiple instances (9 or 10) of the IMD Windows application,
following error was received:<o:p></o:p>
SqlUtility Execute Error: Transaction (Process ID 65) was deadlocked on {lock}
resources with another process and has been chosen as the deadlock victim. Rerun the
transaction.<o:p></o:p>
<o:p></o:p>
I am not sure as to what could be the cause of these problems??<o:p></o:p>
<o:p></o:p>
I am thinking of the following options:<o:p></o:p>
Increase the value of command.Timeout property, so that connection timeout
period is increased. This would solve issue #1.<o:p></o:p>
Increasing the interval of the timer so that we ping the database at a lower
rate? (once in 3 minutes). This would solve issue #2.<o:p></o:p>
<o:p></o:p>
Can someone suggest a solution to the above problem or provide valuable tips/new
approaches to counter this problem.<o:p></o:p>
<o:p></o:p>
I need to solve this problem ASAP. Please reply ASAP.<o:p></o:p>
<o:p></o:p>
Thanks and Regards,
Kailas<o:p></o:p>
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
