How to resolve ProviderSuite Database Performance Issues

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 ...