on 07-03-2008 4:20 PM
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
hello sir u do every two months archiving send old data to external disk and check performance in st04
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.