DON'T clear the server. That will do nothing except cause 24 to 48 hours of headaches.

Are you saying that when you run AC on the server it takes up 28GBs of RAM. That is crazy. It shouldn't take more than 150MBs of RAM

I would let James remote in and use SSMS and see what the time of queries are. Should be milliseconds. But if way more there is a problem. Do you have the OS working as a host so you can run a VM and isolate AC there?

Also, has AC looked at it? Are you on the latest version? If James can't look at it, my IT guy would probably look around for free. Why is it using 25GBs of RAM.


Bert
Pediatrics
Brewer, Maine