Post reply

Transaction Timeout

  • August 2, 2010 at 6:32 am

    #103963

    Good Day.

    We are running an SQL Server 2008 Database . Every 5 minutes a job inserts data into a table . This job runs for 30 seconds . We also have users who sign on , but htey are experiencing timeouts . Is there any soltion to prevent htese timeouts ? We created the indexes as suggested by the system, but the issue is still not resolved . Any ideas ?

    Regards.

    Lian

  • August 2, 2010 at 7:06 am

    #1200980

    not sure but try with no lock

    or

    define your select queries so that it not goes uptill the inserted record.

    ----------
    Ashish

  • August 5, 2010 at 11:22 pm

    #1203255

    its a job that runs for 30 sec....i dont think that job is the problem.u can use counters or run a trace or

    just run sp_who2 and check which process is taking a long time.

  • August 17, 2010 at 9:21 am

    #1207960

    Lian,

    You'd have to provide more information about what is happening. I assume you mean query timeouts from the table(s) that the job affects? What does the job do? What are your query timeouts? Are things being blocked? Have you checked for that?

  • July 26, 2016 at 9:07 am

    #1892074

    Hi,

    I want to change the MSDTC transaction timeout setting from 60 to 600 in a SQL 2014 Cluster environment, do i need to reboot the database server or the MSDTC service to take effect.

    Thanks!

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

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