I would like to know what is the purpose of the table "sloresponsehist". There is a table called "sloresponse" which i am aware of.
We have our transactional databse synced with reporting databse. There is a delay of 2 hours between transactional and reporting because the table "sloresponsehist" is taking too much time. We are considering not to sync this table with reporting databse. Before we take this approcah iwould like to know what is the purpose of this table and if it is ok not to sync this table with reporting database.
In the sm 9.41 release notes, it has this bit of info. If you are not going to report on sla, it should be fine to ignore this historical table but that is unlikely as sla reporting is very common.
There is no way to monitor UC and OLA because the sloresponse records are deleted when the incident no longer has the vendor field or the incident is passed from one assignment group to another. The sloresponse records contain valuable information for Service Level Management (SLM) and should never be deleted.
Now the sloresponse records are logged in a new table sloresponsehist. Every time when the SLM calculation is triggered, the data of the related sloresponse records is logged to the new table, so that historical data is kept in the system.