Collecting Administration Performance Data for Troubleshooting

Problem: You need to collect performance data to troubleshoot performance issues in Sybase Control Center for Unwired Platform administrative options.

Solution: Set up the <UnwiredPlatform_InstallDir>\SCC-XX\log\executionTime.log, which provides information on the length of time taken to complete operations in Sybase Control Center. Sybase Product Support and Engineering teams can use this information to diagnose the source of your performance issues. To set up this log file:

  1. Open <UnwiredPlatform_InstallDir>\SCC-XX\plugins\com.sybase.supadminplugin\agent-plugin.xml.
  2. Add the following line to the file under the <properties> element: 
    <set-property property="log_MO_method_execution_time" value="enable_log_mo_method_execution_time" />
  3. Open <UnwiredPlatform_InstallDir>\SCC-XX\conf\log4j.properties.
  4. If you are experiencing log truncation issues, edit the following lines to change the default values for maximum file size (default: 5MB) and maximum backup index (default: 10 files) to the values shown in this example:
    ## file appender (size-based rolling)
log4j.appender.executionTime=org.apache.log4j.RollingFileAppender
log4j.appender.executionTime.File=${com.sybase.ua.home}/log/executionTime.log
log4j.appender.executionTime.layout=org.apache.log4j.PatternLayout
log4j.appender.executionTime.layout.ConversionPattern=%d [%-5p] [%t] %c.%M(%L) - %m%n
log4j.appender.executionTime.MaxFileSize=50MB
log4j.appender.executionTime.MaxBackupIndex=20
## log MO method execution time
log4j.logger.com.sybase.uep.sysadmin.management.aop=INFO,executionTime
  5. Restart SCC.

    The executionTime.log file now appears in the <UnwiredPlatform_InstallDir>\SCC-XX\log folder.

Use this log file to diagnose and analyze performance problems. For more information on configuring the agent-plugin.xml configuration file, search for Agent Plugin Properties Reference in the System Administration guide.

You can also use the Adobe Flex log to track performance in Sybase Control Center. To access Flex-side logging, highlight the resource in the Perspective Resources view and select View Log to show the user interface time for each activity. Alternately:

  1. Modify the <UnwiredPlatform_InstallDir>\SCC-XX\plugins\com.sybase.supadminplugin\agent-plugin.xml file as indicated in step 2, above.
  2. Restart SCC.
  3. Log in and perform your regular administrative tasks.
  4. View the execution time indicators for these operations in the cookie file supatcookie.sol. The location of this file varies depending on your operating system:
    Operating System Location
    Windows XP C:\Documents and Settings\<username>\Application Data\Macromedia\Flash Player\#SharedObjects
    Windows Vista C:\Users\<username>\AppData\Roaming\Macromedia\Flash Player\#SharedObjects
    Macintosh OS X /Users/<username>/Library/Preferences/Macromedia/Flash Player/#SharedObjects
    Linux /home/<username>/.macromedia/Flash_Player/#SharedObjects
  5. Analyze the log using your preferred method of data analysis.
Parent topic: Troubleshoot the Sybase Control Center
Related concepts
Sybase Control Center Management Tier Issues
Server Tier Administration Issues
Application and Application User Management Issues
Related tasks
Using Sybase Control Center to Troubleshoot Unwired Platform