My current Inventory database is giving me the On Hand Qty, Value, etc… as of NOW (current date), but I am thinking of utilizing the Retain Snapshots to start gathering historical data. For example, if we currently have 50 on hand of Item A, I might want to know how many Item A we had on hand last week. We may also want to know how many we average on a monthly basis.
Anybody in the group utilize the Retain Snapshots for their Inventory databases? Is there any storage concerns or anything else to keep in mind?
My sql for my Inventory database is currently using GETDATE(), which creates my date_id and then my SYNC runs each morning at 05:00.