Question

2
Replies
3263
Views
MUELM Member since 2012 5 posts
PEGA
Posted: November 30, 2016
Last activity: January 17, 2017
Closed
Solved

PEGA0005 alerts on system tables

Article SA ID: SA-22532 indicates it was written for pega alerts in 7.1.6:   https://pdn.pega.com/support-articles/pega0005-alerts-alert-logs

If we are experiencing the same in 7.1.9,  and have the following errors:

1) Database update took morethan the threshold of 250 ms: 7,329 ms update xxxx.pr_sys_statusnodes set pyLastPulseDateTime = ? where pzInsKey = ?

2) Database operation took morethan the threshold of 250 ms: 6,607 ms SQL: {call xxxx.sppr_sys_updatescache_gettime (?,?,?)}

Are the same indexes still valid?  Or are there new indexes we need to build?  The second item above is not mentioned in  the original article.  Are there separate indexes for that stored procedure? 

 

 

 

System Administration
Moderation Team has archived post
Share this page LinkedIn