Originally Posted by Tomastoria
In any event, we seem to have to reboot the server every couple of weeks -- and there are all sorts of reasons why that is so.

thank you for hanging in and being there


This happens as the memory allocated to SQL reaches a maximum of 1GB. The cache gets filled and you have to start reading from the disk. Rebooting flushes the cache and things speed up again. You can also just restart the Amazing SQL database instead of restarting.

net stop mssql$AmazingCharts
net start mssql$AmazingCharts

A long term/hands-off solution would be to schedule it nightly or weekly or switch to SSD's/full SQL for even greater performance.

Sandeep Luthra | LTMedical.net
2023 Practice Systems now available