Question

4
Replies
118
Views
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 221 posts
Anthem
Posted: January 13, 2020
Last activity: January 21, 2020
Posted: 13 Jan 2020 8:02 EST
Last activity: 21 Jan 2020 12:06 EST
Closed

Slow running sppc_data_uniqueid_withouttran store proc in Production Environment.

Hi Team,

High counts of following slow running Stored Procedure sppc_data_uniqueid_withouttran has been observed in the production environment (PRPC731,MSSQL and TOMCAT).

1) What is the functionality of this SP ?

2)What factors can contribute to its frequent and slow runs and the probable impacts it can cause to the applications?

3) Recommendation or Optimization steps to resolve ?

Thank you.

System Administration Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.