cancel
Showing results for 
Search instead for 
Did you mean: 

High database growth

Former Member
0 Kudos

Hi ,

W e are in version 4.7 .

Our worry is current database is 980 GB and per month database growth is 55GB . We want to restrict the database growth as early as possible otherwise it is hampering system performance.

We want to know the followings :

1. Steps to follow to control the growth

2. At what level we have to start our analysis database / application level

3. What are the areas we have to check database / application level

4. At applicable level any way to check the customization which is unncessary creating chain / multiple transactions.

Regards,

mukesh Badhwar

+91 - 9810449604

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

hello sir u do every two months archiving send old data to external disk and check performance in st04

Former Member
0 Kudos

Hi Mukesh,

Just want to add some information.

If you still can't find out what is your problem, may be you can consider to get a "Data Management" service from SAP

This service cover data archiving and data avoidance

There are some customizing that by default was on

And some company no need the data, so you can turn if off to reduce the monthly growth.

Regards,

Fendi Suyanto

Former Member
0 Kudos

Hi

I would suggest you to go through given below Link,which will give you enough idea which are the tables normally need space management at regular intervals.

http://help.sap.com/saphelp_nw70/helpdata/EN/08/5742084ae611d1894f0000e829fbbd/frameset.htm

Tables are given below.

PSAPBTAB

Transaction data tables. Objects in this tablespace might expand very rapidly.

PSAPSTAB

Master data tables. Objects in these tablespaces might expand very rapidly.

PSAPCLU

Clustered tables, such as financial tables. Objects in these tablespaces might expand very rapidly.

PSAPPOOL

Pool tables, containing customization tables.

PSAPPROT

Spool (that is, print) requests, protocols

Based on the size you many need to use brtool to add tablespace.

Thanks

Sukrut S

markus_doehr2
Active Contributor
0 Kudos

I would start with ST04 and see which tables are growing most. Then, having that information, dig deeper depending on what table is affected.

Markus