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.
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/