ARO and performance

Tanya_Shipunov

Can someone please share their experience implementing ARO, particularly in regards to its effect on the db performance? Given ARO installation page features this important note: "Advance Request Offering management pack will update ALL of your Incident and Service Request Last Modified dates for each work item in the ServiceManager CMDB. On large data sets this can and will result in performance issues while Service Manager processes the changes across the affected work items. This is a core Service Manager function (limitation) and therefore nothing we can do to alleviate or remedy these effects." How large should be the data set to experience performance issues after ARO implementation? Thank you

Brian_Wiest

We had 40K work items when implemented and it did not take long for the WI's to update. (Less then 10 minutes) 
Our biggest issue was management not being happy that every item last modified date was updated. 
We make use of 
https://community.cireson.com/discussion/1700/scsm-last-modified-date-manager-for-ir-and-sr
These reverts the dates back in less then a minute. 

Brian_Wiest

We had 40K work items when implemented and it did not take long for the WI's to update. (Less then 10 minutes) 
Our biggest issue was management not being happy that every item last modified date was updated. 
We make use of 
https://community.cireson.com/discussion/1700/scsm-last-modified-date-manager-for-ir-and-sr
These reverts the dates back in less then a minute.