Hello, users. I am a server technician who was hired to alleviate the unresponsiveness of the 8.2.2 program for a practice in the Midwest. What I've learned so far is this. Disk I/O is at a premium. Even with a single SSD, disk reads were well below what the drive was capable of simply because the program is not requesting the data in the most efficient way. Switching from one SSD to three working together (RAID) provided a noticeable increase in performance. (1-2 second increase in "pull chart" function, ~1 second increase switching between tabs, 2-3 second increase closing patient chart) But there was still a significant delay. Further digging proved the SQL Server Express 2012 that installs with Amazing Charts to be the culprit. with the disk I/o maximized, we discovered that the program was only taxing a single processor core. This was tracked back to SQL Express. it is here that I am now, as I am unable to test with full sql over the weekend to see if it will utilize all available cores for database requests.
Does anyone know if there is a way to push DB requests to SQL without calling Amazing Charts support?
