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 |
Problem
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:
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
|
|
Related Articles
Legacy ID
317989
Article URL http://www.symantec.com/docs/TECH67066
Terms of use for this information are found in Legal Notices
Thank you.