Siebel Application Performance Impacted by MS SQL error [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot continue the execution because the session is in the kill state. (Doc ID 2611460.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Symptoms

Long running SQL queries causing slow performance issues for object manager tasks. Siebel end users not able to execute SQL on Service Request Detail View.

For Example: The S_EVT_ACT is the biggest table and all queries are showing slow performance or SQL failures. The corresponding Object Manager logs are showing MS SQL Database connectivity errors when you executing SQL:

Further noted high CPU spike issues on Microsoft database SQL server.

Changes

 Applied the SP2 on Microsoft SQL Server 2016 database

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.