Supprt

Doodad Boy

<div>
They receive below error<br>Msg 596, Level 21, State 1, Line 11<br>Cannot continue the execution because the session is in the kill state.
</div>


They receive below error
Msg 596, Level 21, State 1, Line 11
Cannot continue the execution because the session is in the kill state.

<div>
&quot;Cannot continue the execution because the session is in the kill state&quot; is misleading in my opinion since it implies your connection session is invalidated but you are still connected however there should be other messages prior to this where you should see the actual exception message you are actually throwing. <br />
<br />
Did you checked the SQL Logs to see if connections are truly killed at SQL level?
</div>


"Cannot continue the execution because the session is in the kill state" is misleading in my opinion since it implies your connection session is invalidated but you are still connected however there should be other messages prior to this where you should see the actual exception message you are actually throwing.

Did you checked the SQL Logs to see if connections are truly killed at SQL level?

<div>
<a href="https://filedb.experts-exchange.com/incoming/2020/04_w16/1450184/error.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2020/04_w16/1450184/error.PNG" class="fr-fic fr-dib"></a>How to confirm if the connection are truly killed at SQL level.Any specific output need to be look in sql log, so i can check the same with my sql engineer.<br>as per the sql log, the above msg i given was share my sql engineer.<br>should we use tool like procmon to capture these log, please advice further
</div>


[https://filedb.experts-exchange.com/incoming/2020/04_w16/1450184/error.PNG]https://filedb.experts-exchange.com/incoming/2020/04_w16/1450184/error.PNGHow to confirm if the connection are truly killed at SQL level.Any specific output need to be look in sql log, so i can check the same with my sql engineer.
as per the sql log, the above msg i given was share my sql engineer.
should we use tool like procmon to capture these log, please advice further

error.PNG

<div>
Hm....there seems to be a lots of similar issues on various rather new SQL versions like this:<br />
<a href="https://social.msdn.microsoft.com/Forums/en-US/0e30a316-dcbb-4cb5-bd2c-eb69b4efad67/sql-server-2016-sp2cui-bug-merge-and-insert-with-columnstore-index-creates-crash-dump-script?forum=sqldatabaseengine" rel="ugc nofollow">https://social.msdn.microsoft.com/Forums/en-US/0e30a316-dcbb-4cb5-bd2c-eb69b4efad67/sql-server-2016-sp2cui-bug-merge-and-insert-with-columnstore-index-creates-crash-dump-script?forum=sqldatabaseengine</a><br />
<br />
and what is the SQL Server version that you are running? I would suggest to check for specific version related similar issue maybe there's some workaround/fix to your problem.
</div>


Hm....there seems to be a lots of similar issues on various rather new SQL versions like this:
https://social.msdn.microsoft.com/Forums/en-US/0e30a316-dcbb-4cb5-bd2c-eb69b4efad67/sql-server-2016-sp2cui-bug-merge-and-insert-with-columnstore-index-creates-crash-dump-script?forum=sqldatabaseengine [https://social.msdn.microsoft.com/Forums/en-US/0e30a316-dcbb-4cb5-bd2c-eb69b4efad67/sql-server-2016-sp2cui-bug-merge-and-insert-with-columnstore-index-creates-crash-dump-script?forum=sqldatabaseengine]

and what is the SQL Server version that you are running? I would suggest to check for specific version related similar issue maybe there's some workaround/fix to your problem.

<div>
<div class="content wysiwyg-content">
Client keep complaining their sql connection being disconnected.<br />
No any network down alert being captured
</div>
</div>


Client keep complaining their sql connection being disconnected.
No any network down alert being captured

Help to analysis procmon log

Network analysis is the process of identifying and remediating the processes and systems within a network, including performance, connectivity and security. The process is performed through the use of tools developed for monitoring and analyzing network activity. Network problems that involve finding an optimal way of doing something are studied under the name combinatorial optimization. Examples include network flow, shortest path problem, transport problem, transshipment problem, location problem, matching problem, assignment problem, packing problem, routing problem, Critical Path Analysis and PERT (Program Evaluation & Review Technique).

Network Analysis

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

Windows Server 2016 is the successor to Windows Server 2012 R2. Built upon the same core code as Windows 10, Windows Server 2016 brings enhancements in security, servicing, and connectivity. A particular focus on this release was hybrid-cloud scenarios, and has close ties to Azure and other Microsoft cloud initiatives. This does not detract from the many improvements that are available for on-premises-only deployments

Windows Server 2016 comes in Datacenter, Standard, and Essentials editions, and for servicing, has adopted windows 10's cumulative model. The new nano-server install is designed to be remotely managed and is designed to be kept current through continuous feature updates. The full GUI install operates similarly to windows 10's "Long Term Servicing Branch" (LTSB) model with cumulative security updates.

Windows Server 2016 has also shifted from a per-processor-and-CAL licensing model to a per-core-and CAL licensing model. This brings Windows Server's licensing more in line with Microsoft's other products and makes hybrid-cloud license planning easier as well.

Windows Server 2016

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.