Question

2
Replies
3351
Views
Michael Mueller (MUELM)
PEGA
Principal System Architect
Pegasystems
US
MUELM Member since 2012 5 posts
PEGA
Posted: November 30, 2016
Last activity: January 17, 2017
Posted: 30 Nov 2016 17:53 EST
Last activity: 17 Jan 2017 4:42 EST
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, 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.