May 7, 2014 at 9:36 am
I have 27 Select Statements OPENQUERY Hung on Server.
I stopped all of the jobs.
I killed 3 of the processes and the process is in a KILLED/Rollback Status. The status of 0% completed for aver an hour.
I never had this get record counts from the AS400 happen before.
When SQL Server gets hung I have to restart the SQL Server Agent Process.
Any ideas?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 7, 2014 at 9:43 am
This is an example of one of the statements that is hung.
There are all the same but selecting from a different object.
SELECT @cnt = AS400TableCount FROM OPENQUERY(LScypR40DAT, 'SELECT COUNT(*) AS400TableCount FROM PMSPSA35')
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply