Thanks for the info on email updates.
Actually, I have been using LMI to stop & restart the service. MOST of the time that seems to resolve the response time issues, but the staff is complaining of response time more than they ever did ~2mo ago & before. And, I don't want them to have the overhead of me or them doing that daily if it can be avoided.
FYI, this is a single practitioner psychiatrist office.
The server is Lenovo with a Xeon E5620 CPU (8 cores at 2.40 GHz), and RAIDed hard drives. The server is running SBS 2011, and was recently (at the start of these problems) upgraded to 16Gb. We upgraded to this server in 2011. At ACs suggestion we installed AC in a VM. I have experimented with memory allocations between the server & the VM. The VM never goes above 3 Gb in use.
My next step was to make an appointment with AC to get their recommendations regarding upgrading to AC version 6.5. They say it uses SQL 2012 which can take advantage of multiple cores. And, would they recommend getting rid of the VM (it does seem there is extra overhead to running the OS for 2 machines.)
I would be very interested in talking with your SQL person. This has become a big headache.
Thanks,
