2 |
Go to the Data Management set of agent parameters. |
3 |
Ensure that the Performance parameter has the True button selected, so that performance data is collected. |
4 |
• |
If the CPU utilization is high for users, but the connections in use are not increasing, go to the SYBM_TopUsers table view to see if a single user is consuming disproportional amount of resources. This view identifies users who have crossed your predefined threshold. |
• |
Open the SYBM_OS_CpuDetail graph view. This graph shows Operating System CPU utilization broken down by each respective ASE engine process. |
• |
Open the SYBM_EnginePerfDetail graph view, where the CPU utilization levels are broken down by Adaptive Server engine. |
• |
From the SYBM_DataCacheSummary graph, drill down on the Hits line to investigate where the cache misses are taking place with the SYBM_DataCacheDetail graph view. |
• |
The Foglight Cartridge for Sybase assists your investigation into database space with the SYBM_DbSpace graph and SYBM_TempDbSpace graph views. Both are identical except that the temporary databases are reported separately.
These views show the data space utilization for the respective database.
Transaction log space is reported separately in SYBM_DbSpaceTransLog graph and the SYBM_TempDbSpaceTransLog graph views.
1 |
2 |
Select the Sybase_MDA Agent and click Edit Properties. |
3 |
4 |
Double-click a Foglight Table Group. |
5 |
See the Foglight online help for more detailed information on editing agent properties.
For each database returned, you can drill down to the SYBM_DbSpaceSegment graph view or the SYBM_TempDbSpaceSegment graph view to see space allocations per segment.
To see database utilization over a period of time, go to the SYBM_DbSpaceTrendChart graph view.
NOTE: You must set Space Trending to True (default is off) in the Data Management agent properties for this agent. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center