Question
4
Replies
104
Views
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.
Hello,
Have you tried to work with your DBA? Any advice from his side with the execution plan maybe?