Question

4
Replies
104
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 208 posts
Anthem
Posted: January 13, 2020
Last activity: January 21, 2020
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