Not sure if this helps any, but I have found 2 issues that have caused me to restart the server.
1). Running out of memory. I have 64G on my windows server and am running MSSQL on same server. MSSQL was configured to use whatever memory is available and sometimes I would find over 95% of server memory used. That used to upset Aware (I assume during some request for more memory).
2). Rules that were NOT ticked do not check referred were triggered and caused massive slowdowns when saving a record. An example, I would bring up inventory maintenance form, and click save (not making any changes) and there would be a 10 second delay. Looking at the log, there are a lot of "child" tables to inventory (order lines, purchase lines, etc. ) and some of the rules would be triggered which caused aware to read a LOT of related rows.
Bruce
p.s. I now find I have to restart about once a week. It is not uncommon for my customer to call me and tell me the system is not responsive and I can't even log onto my app. Restarting the app does fix the issue.
