We have a client with Servicedesk 12.5 (in the progress to migration to 14.1) and we have noticed that the information in the table usp_kpi_ticket_data is not written in real time. As a matter of fact, revisiting the table with difference of days, shows new information written from records that were not previously there. So the question is, does anyone knows how the KPI daemon works?. Could it be possible that it be writing info four of five days later for an implementation of near 900 concurrent analyst and 150K to 200K tickets a month?.
I would appreciate any guidance on how this daemon works and suggestions to improve its performance