We recently ran into an issue of our FNMP database running out of space and its hosted on a shared instance.
Wondering if we have any data archiving process or solution with in FNMS itself.
If the data can be archived/purged, any data older than some period of time.
Or any other suggestions, other than having a dedicated instance for the database.
Aug 09, 2019 11:12 AM
There is no built in archiving. Here are some questions, you might want to ask if you are looking for a custom solution:
Depending on thee answers, you might want to design
Aug 12, 2019 09:27 AM
The following thread contains some discussion about deleting old history data (which will typically become the largest amount of data held in the database over time): History table deletion scripts
Aug 12, 2019 02:28 PM
Couple of other variables to consider,
Is it Temp space running out or the whole database. FNMS is a very large TEMPDB user. I had to work with my DBA's since it's TEMPDB use is very high compared to most databases.
Do you monitor software usage? If so, that will cause lots of growth issues as well as performance issues. (extends reconciles dramatically over time) You may want to look at some of the helper file launches the db maintains for licensed products and do a delete from SQL Management Studio directly. I need to do it quarterly in my environment.
Aug 15, 2019 10:02 AM