What are processes doing in the database? Sounds like they are creating and holding locks on the same set of objects in the database . As you have found out, this doesn't scale.
Without knowing exactly what your code is doing, here's a link to some general tips for avoiding the problem. http://www.sql-server-performance.com/deadlocks.asp On 10/24/05, Krishnan <[EMAIL PROTECTED]> wrote: > > Hi, > > How to solve the deadlock problem in MS SQLServer 2000. My application is in > C#. > In my application, I have to run the other different Exe's from my > application. > I am starting the processes through Process.Start() method. > > the code look like below. > System.Diagnostics.Process objProcess ; > :: > objProcess = new System.Diagnostics.Process(); > :: > objProcess.StartInfo.Arguments = strParameter ; > objProcess.Start(); > > there may be situations where i may have to start the same exe at the same > time. the same exe's will be running parallel. > the number of exe can also be large in number. in those cases, i am getting > the Deadlock problem and all my exe that are running are stopped abruptly. > Is there any solution to solve this problem. > > Regards, > Krishnan > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
