Online Tutorials & Training Materials | STechies.com
Register Login

Data Collector Performance Issues in DBA Cockpit

02 Feb 2016 2:29 pm || 0

What are Data Collector Performance issues in DBA Cockpit? 

DBA Cockpit for SAP Sybase ASE sets up a number of data collectors. The default history spans a time frame of 14 days with a default collection interval in the range of 15 to 60 minutes. You can expand this history size or increase the frequency of data collection according to your needs. This will cause larger tables in the saptools metrics repository and can lead to severe performance issues due to missing index support while the data collectors are attempting to delete data that has dropped out of the configured history.

Solution

Import the appropriate Support Package for SAP Basis. Alternatively, implement the correction instructions that are attached to this SAP .

After correction has been imported:

  1. Log on to the DBA Cockpit.
  2. Navigate to Configuration -> Data Collection Framework -> Collector Configuration.
  3. Repair all data collectors.
  4. If the SAP Sybase ASE version is lower than 15.7.0.110, run the following SQL script to update index statistics:

USE saptools

go

DECLARE TAB_CURSOR CURSOR FOR SELECT name FROM sysobjects WHERE type = 'U' AND name like 'DBH_STG_%'

go

DECLARE @tabname VARCHAR(255)
DECLARE @cmd VARCHAR(255)
OPEN TAB_CURSOR
FETCH TAB_CURSOR INTO @tabname
WHILE @@sqlstatus = 0
BEGIN
SELECT @cmd = 'update index statistics [' || @tabname || ']'
print "%1!", @cmd
EXEC( @cmd )
FETCH TAB_CURSOR INTO @tabname
END
CLOSE TAB_CURSOR
DEALLOCATE TAB_CURSOR
go