Insufficient memory error, Error: 26073,TCP error, orphaned spids in KILLED/ROLLBACK. SQL2012 SP2, ENT ed!
Several times today these errors appear in this sequence and the server is hung until we bounce app servers/kill spids: 1. Error: 26073, Severity: 16, State: 1. 2.TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support 3.Failed allocate pages: FAIL_PAGE_ALLOCATION 438 4.Memory dump 5.There is insufficient system memory in resource pool 'default' to run this query. 6.thousands of spids in KILLED/ROLLBACK;appear to be orphaned spids **Any help is much appreciated
Along with the 'insufficient system memory' message in the error log, there should be results from DBCC MEMORYSTATUS - if those can be posted they may also help with diagnosis. In Twitter #SQLHelp, you indicated no added Resource Governor resource pools, which eliminates one potential cause of OOM messages. Is CLR being used? Or Extended Events?