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:
Siebel CRM - Version 15.0 [IP2015] and laterInformation in this document applies to any platform.
Microsoft SQL Server 2016
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |