ADS.EXE maxing out CPU Usage at random times

[Former Member]

I use Advantage Database Server with McKesson's Medisoft Practice Management Software for physicians. I recently started having issues with the ADS.EXE process maxing out or running very high and causing the Medisoft Application to lock up. It will run at a very high CPU usage from 10-45 minutes and then drop back down to normal. This is ADS 11.10.0.22 64bit on a Server 2008 r2 Datacenter (HyperV VM) with 12GB RAM and 4 processors. How can I figure out what is causing this random and sudden spike in CPU usage?

[Former Member]

McKesson may be best to help you trouble shoot this issue.  However, I'll give a suggestion.

If the application is primarily using SQL Statements you could try writing something to regularly call the procedure sp_GetSQLStatements to dump out which statements are running.  Then investigate the ones that are running at the time of the freeze.

http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11.1/index.html?master_sp_getsqlstatements....

Another possibility to look at is using Query Logging to have hte server automatically log all queries (not just un-optimized ones) and see what queries may be running

http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11.1/index.html?master_sp_enablequeryloggin...

Finally, it may sound wierd, but check the Windows OS (both on the VM and host) and check that the Power Plan is set to HIGH Performance.  Also check the Bios for any settings related to power settings.  Once set to High performance reboot the machine and test again.

http://devzone.advantagedatabase.com/forum/questions/1566/why-is-ads-slower-when-installed-on-window...