Skip to Content
0
Sep 10, 2009 at 07:17 AM

Regions and collisions

37 Views

Folks;

in preparation for an internal (non-SAP) training related to MaxDB performance analysis and tuning, I am taking a first look at the relevant tools to get an impression of what's possible and what not. Dealing with x_cons I stumbled across the following thing:

bflow@pvdbsrv:~$ x_cons BFLOWDB show regions

SERVERDB: BFLOWDB

Index  Region    Owner    Get-Cnt    Tas-Cnt      Coll.    Waits Excl   Coll % 
    1  PAGER                19393          1      75226      585    0 387.90 %
    2  CONFIG                   0          0          0        0    0   0.00 %
   ...
   27  SERVER              131145          0          3        0    0   0.00 %
   28  SRVTASK              12346          8      12906      122    0 104.54 %
   ...

Browsing this pages, I found (1) and (2) to be of interest yet not completely resolving my questions, especially related to the, well, oustandingly high collision rate related to the PAGER region. Should I be worried?

Thanks in advance and kindest regards,

Kristian

(1) max-dblivecache-regions

(2) http://wiki.sdn.sap.com/wiki/display/MaxDB/SAPMaxDBRegions

Edited by: Kristian Rink on Sep 10, 2009 9:17 AM

Edited by: Kristian Rink on Sep 10, 2009 9:18 AM