cancel
Showing results for 
Search instead for 
Did you mean: 

Database Performance (DB02) interperting

Former Member
0 Kudos

Hi,

I was going over DB02 T-code. I need to know, how to read the <b>missing indexes</b> info. I saw some info that if any indexes supplied by SAP in DDIC is deleted, this error may popup.

Can anyone help me out, to get more detailed info and interpertations of DB02 monitoring.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

mail me at bapujeenaidu@gmail.com and I'll send u good docs for database and workload analysis.

Former Member
0 Kudos

Hi Bapu,

I mailed to your email id. Please send me the doc links. Thanks in advance.

Former Member
0 Kudos

Hi,

I have sent a mail to you, can you pl. send me the doc's

thanks

Bala

Answers (1)

Answers (1)

Former Member
0 Kudos

the importart info that you can find on DB02, are:

->space critical obj (ex. no space in tablespace)

->refresh -->dbcheck&update (if is not scheluded in db13)

->check-->db e abap dictionary

->current/statistics/free of tablespace (ex to know the size and history of the tablespace)

About the missing index, this monitor checks possible problems with the db index: if some index will not result, problably the search on db can be veeeery slow (ex. the missing it's possible after a reorg).

Regards

Cristian