SQL Server Performance

sql server stored procedure

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by deepak.baran, Nov 7, 2010.

  1. deepak.baran New Member

    hi sql experts,
    I run a financial application. There is a stored procedure which calculates commission and consists of many queries and sub-queries. When i run this procedure I am not able to run other sp while commission sp is running.
    Can anyone help me what could be the issue here.
    Thanks in advance.
    deepak.baran, Nov 7, 2010
    #2

  2. FrankKalis Moderator

    Without seeing the code (only the part which you deem to be relevant, please). we can't suggest anything sensible.
    FrankKalis, Nov 8, 2010
    #3

  3. Adriaan New Member

    With the same reservation that Frank made, but it could also be an issue in the client application. If your client app starts the procedure as an synchronous process, the client app will hang until SQL returns a result.
    Adriaan, Nov 8, 2010
    #4

  4. deepak.baran New Member

    Hi Adriaan,
    I am using i-net SPRINTA 2000 driver in my java application. Any idea how to run as asynchronous process.
    Thanks
    deepak.baran, Nov 8, 2010
    #5

  5. satya Moderator

    Your question is totally out of SQL server, in this regard you must check in JAVA related forums for such information.
    In any case unless the code is posted here it is hard to suggest the way out.
    satya, Nov 27, 2010
    #6

Share This Page