Post reply

Processing Priroty

  • October 13, 2004 at 11:19 pm

    #89729

    Hi guys

    Need your help once more.

    I am running two Sps from my Java program(Weblogic server) via Ibatis.

    The first Sp (say SP1) is run with no transaction management in weblogic/IBatis. The entire transaction management is being done by SQL Server 2000 itself.

    While the second SP (SP2) in fired with a nonTransactional datasource and the transaction management is acheived through IBatis not SQL Server 2000.

    My problem is that when the SP1 is running, I fire the SP2 also. What I see that SP2  is getting timed out after 33 seconds. I have checked the tables in contention. There is no conflicting locks that is causing the SP2 to wait and hence get timed out. It is just that the SP2 does not get a chance to execute when SP1 is running. It has to wait for its slice of processor time, before which it gets timed out. I cannot see any trace of the SP2 in the profiler also.

    My question is is there any mechnism via which I can run SP1 on a less important thread, so that SP2 gets run immediately when its fired. Is there any mechanism to set Process Priority in SQL server 200?

    Hope I could make myself clear

    Wiating for ur responses

    Regards

    SG

  • October 14, 2004 at 7:30 am

    #526715

    No ou cannot set thread priority for each item. You may want to rethink your transaction management and let all be handled in SQL 2000, but without a lot more detail that may not be the best thing either.

  • October 14, 2004 at 10:26 am

    #526773

    What about a delay between the start of execution? Or call 1 proc and have it fire the other 2?

  • October 14, 2004 at 11:34 pm

    #526872

    Thanks guys..But I already have a delay betwen the two.

    I cannot call the 2 SPs from 1. Cause that 2nd depends on user interaction.

    Thanks

    SG

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply