How to resolve ProviderSuite Database Performance Issues
General database performance issues
1. Identify and kill transactions that could be causing the problem
- Result = transaction restarted, some users could be affected
- Risk = kill a critical transaction that corrupts data
2. Stop/Start the SQL Job Agent service
- Result = jobs restarted, users not affected
- Risk = none
3. Stop/Start Database Engine service (includes SQL Job Agent) (Jake =
Restart SQL)
- Result = all users exited from system until complete
- Risk = goes into recovery mode for a long time
4. Reboot server that hosts SQL Server
- Result = all users exited from system until complete
- Risk = server takes a long time to recover
Log File Issues
Shrink log and then run update stats
Related Articles
End of Support for ProviderSuite Web Scheduler; Migration Path to ProviderSuite Scheduling Applet
As of January 31, we will no longer support the ProviderSuite Web Scheduler (also known as Schedule Manager 1.0) and, as of December 31, all customers still on Web Scheduler will need to have migrated to Scheduling Applet 2.0, the current scheduling ...
Performance 2 - System Slowness
Your report of general system slowness has been logged with the technical team When entering a ticket, we like as much information as possible about what part of the software you were in and what you were doing when you started to see the system ...
ProviderSuite 7.2 Release Notes
ProviderSuite 7.2 Release Notes are attached to this article. Manage Patient Payments Easier The Patient Payments functionality of the Billing Manager applet (Billing Manager> Accounting> Patient Payments) has been added to the Web App. This new ...
Exporting Data from ProviderSuite
There are three primary ways to get data out of ProviderSuite: Reports ProviderSuite has many reports available via the Reports tab. These reports can be saved to Microsoft Excel or printed. Depending on your needs, there are various claim, payments, ...
Speed Test
During an unexpected performance issue, please follow the steps below to rule out any possible ISP issues. Click on this link to access the Ookla Speed Test. Click "Go" to begin. Once completed, please take a snip/screenshot and attach it to the ...