Question

4
Replies
82
Views

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.