Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Select Statements OPENQUERY Hung on a Server Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 9:36 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:15 PM
Points: 4,262, Visits: 4,309
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/

Post #1568545
Posted Wednesday, May 7, 2014 9:43 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:15 PM
Points: 4,262, Visits: 4,309
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/

Post #1568552
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse