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

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

    • ProviderSuite 8.1 Release Notes

      ProviderSuite 8.1 Release Notes Table of contents Customer Release Notes ProviderSuite Web App Version 8.1   Contents ProviderSuite Web App PBI 1610: Updated Billing tab UI and renamed to Claims tab PBI 1572: Renamed Scheduling to Appointments PBI ...

    • Launch Billing and Launch Scheduling Applet Issues

      Steps for Resolving Launch Billing/Launch Scheduling Issues: Verify Internet Browser Settings   1. Confirm that any pop-up blockers are turned off or you have given permission to the PracticeAdmin applications to pop-up. 2. Review Google Chrome ...