Dynamic Threshold - Report Displays becoming CPU Intensive

[RyanDavis]

I have been working on displays using the data stored on the Dynamic Threshold database but, I have noticed the displays are starting to become taxing on the CPU.  Is there a way to optimize this display anymore without sacrificing the history length or am I simply gonna have to increase the # of CPU cores? Just looking for opinions.

Dataview Definition Where Clause:

Approval

SRCNODE = "\" AND REMASSOC = "TOTAL" AND FIELD = "APRV%" AND PROFILE = "DayOfWeek3Month"

Decline

SRCNODE = "\" AND REMASSOC = "TOTAL" AND FIELD = "DENY%" AND PROFILE = "DayOfWeek3Month"

Refresh Rate: 5 Minutes

Chart Intervals: 4032

Label Every: 288

Database: DynamicThresholdDBCol

Period: Start 14 Days Ago -> End of data

Collection Interval: 5 Minutes 

- No end user load on the top level node in this screen capture. 

[GeraldC1 · Accepted solution]

Hi There,

Chart Intervals: 4032 tends to stand out as being a lot of data points to draw when most PC monitors have less than 2000 pixels across. So first thing to try I'd suggest larger interval (10 minutes or 20 minutes or ...) for half or quarter the number of data points to plot. If that can't be done using the DynamicThresholdValues (DTVALUE) record you're using, then the corresponding transaction summary record might be a better choice as the denial, approval fields are of type Average in those records. Even create a database collection of the transaction summary record for it if necessary.

HTH