Data necessary to troubleshoot CommandCentral Storage performance issues

Article:TECH67066  |  Created: 2009-01-23  |  Updated: 2009-01-23  |  Article URL http://www.symantec.com/docs/TECH67066
Article Type
Technical Solution

Product(s)

Environment

Issue



Data necessary to troubleshoot CommandCentral Storage performance issues

Solution



NOTE: It is very important to collect evidence during the time when performance problem is happening.  Otherwise, the collected evidences will not reflect the issue.

On some systems QueryDB.bat or QueryDB.sh may be named QueryDB_RO.bat and QueryDB_RO.sh.  Please use the correct script name for your system.

Download the attached Queries.zip file and extract the four SQL files to the following location:
Windows:  
\Program Files\VERITAS\CommandCentral Storage\HAL\bin
Solaris:  
/opt/VRTSccs/VRTShal/bin

Data Collection:

1.  Get HAL database version, HAL database schema version, and GUI hotfix version

Windows:
a) cd to \Program Files\VERITAS\CommandCentral Storage\HAL\bin    
b) #QueryDB.bat getHALDBversion.sql
Solaris:
a) cd to /opt/VRTSccs/VRTShal/bin
b) #./QueryDB.sh getHALDBversion.sql

Collect the output files - haldbversion.txt & guiversion.txt

2. Get the last 24 (or 48) hours of HAL log on Management Server

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\HAL\bin
    b) #hallog view -t 24:00:00 > hallog.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTShal/bin
    b) #hallog view –t 24:00:00 > hallog.txt

Collect the output file - hallog.txt

3. Get HALCHM Task Listing on Management Server

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\HAL\bin
    b) #halcmd –A HALCHM –c task.lt > tasklist.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTShal/bin
    b) #./halcmd –A HALCHM –c task.lt > tasklist.txt

Collect the output file -  tasklist.txt

4. Get connection activity output on Management Server

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\Support\Tools\bin
    b) #QueryDB.bat getConnectionActivity.sql > connectactivity.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTSccsts/support/tools/bin
    b) #./QueryDB.sh getConnectionActivity.sql > connectactivity.txt

Collect the output file -  connectactivity.txt

5. Get connection info output on Management Server

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\Support\Tools\bin
    b) #QueryDB.bat getConnectionInfo.sql > connectinfo.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTSccsts/support/tools/bin
    b) #./QueryDB.sh getConnectionInfo.sql > connectinfo.txt

Collect the output file - connectinfo.txt

6. Get database locks

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\Support\Tools\bin
    b )#QueryDB.bat getLocks.sql > dblocks.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTSccsts/support/tools/bin
    b) #./QueryDB.sh getLocks.sql > dblocks.txt

Collect the output file - dblocks.txt

7. Get HALCHM performance data on Management Server

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\HAL\bin
    b) #perl.cmd CHMPerformanceData.pl –c –o chmperf_<date>.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTShal/bin
    b) #./perl CHMPerformanceData.pl –c –o chmperf_<date>.txt

Collect the output file - chmperf_<date>.txt
Note: replacing <date> with current date.

8. Get a list of explorers with pending updates

Windows:
a) cd to  \Program Files\VERITAS\CommandCentral Storage\HAL\bin
b) #QueryDB.bat agent_dctneeded.sql
Solaris:
a) cd to /opt/VRTSccs/VRTShal/bin
b) #./QueryDB.sh agent_dctneeded.sql

Collect the output file - agent_dctneeded.txt

9. Get output of halchm.activity table on Management Server

Windows:
     a) cd to \Program Files\VERITAS\CommandCentral Storage\Support\Tools\bin
     b) #QueryDB.bat getactivity.sql
Solaris:
     a) cd to /opt/VRTSccs/VRTSccsts/support/tools/bin
     b) #./QueryDB.sh getactivity.sql

Collect the output file - activitylisting.txt

10. Get tables summary output

Windows:
    a)cd to \Program Files\VERITAS\CommandCentral Storage\Support\Tools\bin
    b)#QueryDB.bat getTablesSummary.sql > tblsummary.txt
Solaris:
    a)cd /opt/VRTSccs/VRTSccsts/support/tools/bin
    b)#./QueryDB.sh getTablesSummary > tblsummary.txt

Collect the output file -  tblsummary.txt


11. Get Profiling Data – This is one of the useful evidence to be collected at the time when performance problem is happening.
  • Turn on Profiling  
  • Replicate the issue or wait 30 to 60 minutes
  • Collect the Profiling data.
  • Turn off Profiling  

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\Support\Tools\bin
    b) Turn on Profiling
         #QueryDB.bat procedureProfilingOn.sql
    c) Wait for 30 minutes (or in the time range of performance replication)
    d) Collect the Profiling data
         #QueryDB.bat GetProfilingData.sql
    e) Turn off Profiling
        #QueryDB.bat procedureProfilingOff.sql
Solaris:
    a) cd to /opt/VRTSccs/VRTSccsts/support/tools/bin
    b) Turn on Profiling
         #./QueryDB.sh procedureProfilingOn.sql
    c) Wait for 30 minutes or (or in the time range of performance replication)
    d) Collect the Profiling data
         #./QueryDB.sh GetProfilingData.sql
    e) Turn off Profiling
         #./QueryDB.sh procedureProfilingOff.sql

Collect the output file -  profiledata.txt

In the specific case of a Database Collection Task for agent explorer takes a long time to complete and causes database locking:
Some additional evidence needs to be collected on the Managed Host.

1. Get device and task listing for specific explorer on a remote Managed Host.

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\HAL\bin
    b) #halcmd -h <hostname >  -A <ExplorerName> -c ssi -c dev.ld -c task.lt  >  mh_device_task_list.txt
Solaris:
    a) cd to /opt/VRTSccs/VRTShal/bin
    b) #./halcmd  -h <hostname> -A <ExplorerName> -c ssi -c dev.ld -c task.lt > mh_device_task_list.txt

Note: Replace <ExplorerName> with the actual name of the explorer. i.e. HiCommandExplorer, EMCClariionExplorer, etc.
        Replace <hostname> with the Managed Host name.

Collect the output file - mh_device_task_list.txt

2. Get object.xml from specific explorer on Manage Host

Windows:
    a) cd to \Program Files\VERITAS\CommandCentral Storage\HAL\bin
    b) #halcmd -A <ExplorerName> -c "data.gao -f objects.xml" –h <hostname>
Solaris;
    a) /opt/VRTSccs/VRTShal/bin
    b) #./halcmd -A <ExplorerName> -c "data.gao -f objects.xml" –h <hostname>
   
Note: Replace <ExplorerName> with the actual name of the explorer. i.e. HiCommandExplorer, EMCClariionExplorer, etc
        Replace <hostname> with the Managed Host name.

Collect the output file - objects.xml

Attachments

Queries_317989.zip (946 Bytes)


Legacy ID



317989


Article URL http://www.symantec.com/docs/TECH67066


Terms of use for this information are found in Legal Notices