Troubleshooting database performance issues

When you observe performance issues with the database, use the following information to enable appropriate logging, troubleshoot and resolve database issues, 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.


Related topics

Troubleshooting-performance-issues-with-AR-System

Contacting Support

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.  Use the following links for more information about troubleshooting database issues:

Action

Reference

Learn to enable appropriate logging, troubleshoot and resolve database issues due to SQL statements, or create a BMC Support case.

Learn to enable appropriate logging, troubleshoot and resolve database blocking issues, or create a BMC Support case.

Learn to resolve issues with large tables in AR System.

Learn to troubleshoot and resolve row-level security issues.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*