Troubleshooting AR System database performance issues

When you observe performance issues with the database, use this information to either perform the appropriate logging and troubleshooting steps to resolve the problem or create a BMC Support case.

The AR System may present performance issues when the underlying problem is with the database. Much of what the AR System server does is heavily dependent on the database. Therefore, database performance and configuration issues are likely to become AR System server performance issues.

Symptom

• AR System is performing poorly due to database performance or configuration issue.

Scope

• A database issue occurs on multiple (or all) servers in a server group that is connected to that database. This may affect all or just a specific type of activity in AR System.

Troubleshooting

There are several specific types of database issues that are commonly seen.  Click on the link below that relates to your specific problem:

• Troubleshooting SQL Tuning issues
• Troubleshooting Database Blocking Issues
• Troubleshooting issues with large tables in Remedy AR System
• Troubleshooting row-level security issues