Recently I worked with a customer who was experiencing a crash in his SQL Server process. He was under the impression that this same code was working in another location but in this envirnonment, they were stressing the box to determine its capacity. That’s when they discovered the crash which eventually led us to find a handle leak in the process.
Steps To Verify Problem
1. Your application uses XA Transactions
2. The sqljdbc_xa.dll file version is 4.2.6420.100
3. Handle count increases with every call [task manager; performance monitor\process\handle count]
4. Once you have exhausted kernel resources, you may also notice related errors:
Log Name: Application
Date: 6/8/2016 6:36:45 PM
Event ID: 4689
Task Category: (8)
The run-time environment has detected an inconsistency in its internal state. This indicates a potential instability in the process that could be caused by the custom components running in the COM+ application, the components they make use of, or other factors. Error in COM\complus\src\inc\UTSem.H(100), Insufficient system resources exist to complete the requested service.
: CreateEvent returned a NULL handle.