Sybase Control Center supports the collection of comprehensive Adaptive Server
configuration and environment data for diagnostic analysis. Sybase Technical Support uses
this information to diagnose server issues, thus expediting customer cases.
The two types of diagnostic data you can collect are:
- Field diagnostic data – includes configuration and environment information about
Adaptive Server at the time it is run. Sybase Control Center invokes the
sybdiag utility command to collect the information.
- Optimizer diagnostic data – provides a way to analyze SQL queries to optimize
their performance. Sybase Control Center invokes the
sp_opt_querystats system procedure to collect this
information.
You can collect diagnostic data for the Cluster Edition of Adaptive Server at both the
cluster and instance levels. For:
- Cluster resource – the local agent that is registered and authenticated in the
agent page is used by to gather diagnostic data.
- Instance resource – the embedded local agent is used to collect diagnostic
data.