Troubleshooting Performance Problems › Identifying Performance Problems in CA SDM › Review General Tuning Recommendations

Review General Tuning Recommendations

We recommend that you monitor the key performance indicators and resource consumption regularly. You can also help ensure that routine maintenance is applied to help identify small problems before they become serious.

If you suspect you see an issue, or if users complain about slow performance, open a CA Support Online issue and send the output from the Interval Logging Script, CA SDM Diagnostic Tool, CA SDM standard logs, and information about the problem. Send this information to CA Support from each CA SDM primary and secondary server.

The following list describes common signs of performance problems:

• Long messages in the CA SDM standard logs (stdlog.x files)
• Search for messages in the stdlogs that state "The following query took #### milliseconds...".
• Queuing on database agents in pdm_vdbinfo output
• Search for Queued Requests(#) in the pdm_vdbinfo output. You can execute this command at the OS prompt manually. The Interval Logging script also executes this command.
• Large number of connected users to each web engine. For example, more than 200 users.

  Note: Execute pdm_webstat to display the number of concurrent users per web engine. You can execute this command at the OS prompt manually. The Interval Logging script also executes this command.

• User complaints