Adept Maintenance - How, When and What do you do?
whyzmuzj
Moderator Posts: 19 mod
Good Afternoon Everyone!
I'm curious what everyone is doing for maintenance of their Adept System.
* Do you currently review your system yearly?
* Do you go back through to clean up old libraries or data fields?
* Do you check the performance of your Adept system?
* Do you archive your Audit Trail?
I've heard of many different processes on how people perform maintenance on their systems. I also know that Synergis provides yearly health checks which I know some of you may take advantage of.
Thanks 
Judie
1
Comments
From the application standpoint, we perform yearly upgrades, we do have a server "team" that tunes db's, views file storage stats, etc. But I myself do not perform any scheduled interrogation or maintenance on our Adept server(s)...
In my case, we actually have a few different implementations of Adept, and each implementation has a Development, Testing, and Production system. I am a part of a team where we have a number of migration and development projects on-going, so we are constantly reviewing out system, and our hardware.
Once challenge we have is ensuring that the Development, Test and Productions systems stay aligned. I typically use some SQL scripts to take a peak at things like the Schema and datacard definitions so the different systems can be compared. We also run analysis on the fields to determine how many of the records are populated, and how many are unique values. We have almost 250 fields in our main system, and many of them are sparsely populated. In other cases, we are looking for some fields which are "regularly occurring" where we may consider Restricted fields, or add the fields to our Quality system to ensure the values are consistent.
I have a Reporting dashboard where we continuously monitor disk space and server performance, and I also pull the server logs routinely and review looking for errors and events which may indicate developing problems.
Finally, we run a script to defragment the Database indexes on a quarterly basis.
So in my case we very actively manage the servers, and the databases and it's content.
Hope this helps
@kklinger the audit trail can be archived at anytime. Things you would want to consider is the size of your Audit Trail table, when I check databases for upgrades I look to see if that is something that should be considered to be done. For many clients who have been running Adept for many many years and never looked at their audit trail table, now is a good time to make an assessment.
For performance checks, what I would suggest is to have a health check performed on your Adept system, you can learn what Synergis AC's look for for performance pieces - including the Audit Trail and if it needs to be archived.
@Cwood3 it sounds like you have a great process to checking Adept performance and maintaining your system.
This test can be run with any user/work area/library combination.
(You can find this by bringing up options->troubleshooting - and clicking on the button at the bottom of that leaf "Performance test..." I'll remind you that any user can view this leaf by holding down the control key when they bring up the option dialog.)
I would suggest running the performance test and saving the report as a snapshot of performance over time. If something changes, this test will provide quantitative data showing what is now slower (or faster) then before.
Synergis Senior Software Developer - primary developer for the Adept Desktop Client