IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

SQL Server deadlocks

  • 1.  SQL Server deadlocks

    Posted Tue October 07, 2003 03:51 PM

    We have been experiencing SQL Server deadlocks on our target application side.


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: SQL Server deadlocks

    Posted Wed October 08, 2003 02:02 PM

    Not sure what you mean.

    The deadlocks are happening on the IS side?
    Are JDBC Adapter services hanging?
    What is your JDBC Connection pool size?
    Does it happen for each call to SQL Server or only under load?
    What version of IS?
    What patches are installed?
    What OS?
    What JVM?
    Can you get a JVM thread dump?
    Is it any operation against SQL Server or a particular one?
    If you are doing multiple updates of a single SQL Server table from different IS threads the SQL Server isolation level will come into play. For instance, page level locks will stop other updates on data in the table until a commit.


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB