September 15, 2011 at 8:13 am
I have a production SQL Server 2000 machine that I have inherited. It is scheduled to be rebooted once/week due to problems with queries hanging. Unfortunately, it's happening more frequently now and I need to figure out what's causing this problem. I'm in the process of upgrading this server but it will take a year to migrate all the DTS packages that have been created.
The error logs are all empty, no errors are returned to the query window. I can run ODBC queries from the machine fine so it appears to just be from the linked server layer. The queries hang from the query window or from SQL Agent jobs. The linked server is using the ODBC driver "IBM iSeries Access ODBC Driver".
I would appreciate any troubleshooting suggestions or if anyone has had a similar problem, what to do to resolve it.
Thanks,
Brian.
September 15, 2011 at 8:32 am
I would like to add that there were other queries that had hung also that did not use the ODBC driver. They were connecting to a remote SQL Server.
Also, there were no blocks in current activity.
Thanks,
Brian.
September 16, 2011 at 9:46 am
you didnt say what you are linking to
I have had queries lock up waiting for the remote server to finish
if you kill them on the local server it locks up forever but if kill it on the linked server it will stop
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply