August 2, 2010 at 6:32 am
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
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
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
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?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 26, 2016 at 9:07 am
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