on 02-03-2012 9:43 AM
Hi,
Can someone explain to me how to calculate the monthly database growth using the ECC6 version of DB02?
In the 4.6C version (now DB02OLD), I can find the difference between the "Size/kb" & "Free/kb" column and from there will be able to compute the monthly DB growth.
With the "new" DB02 (ECC6.0), how do I do that?
Thanks
Since, Other have already explained how to calculate in ECC. The otherway is EWA in solution manager will give you the report weekly where you can see the DB size growth in values and graph.
Refer to below link for more information
http://help.sap.com/saphelp_em70/helpdata/en/43/b56c35306d1bbce10000000a1553f7/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have two options here
1) enter t-code db02old which will works as same old db02
2) instead directley goto DB02 -> space-> Database -> Overview
In the Overview window select History tab ,there you can see history for Days, Weeks and Months.
Regards,
Srini Chapa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Once you are on Months tab ,you will se the following detaisl
Date Name Size(Gb) Chg .Size Free(Gb) Used %
<month date > <syste name> <total DB size> <change in DB size> <total free space> <% used >
from the above you can come to know abt DB growth by comparing the last two months DB Size.
Regards,
Srini Chapa.
Hi,
Please follow this navigation:
DB02 --> Space --> History --> Place your cursor on "Database and Tablespace" --> On your right hand plane, For field "Statistics" Choose "Month" --> Then click on "Details" icon (Magnifier Symbol) --> That will provide you with table statistics of your database space.
Please calculate the growth as follows
Date (Month) Total (KB) Used (KB) Growth (KB)
10/01/2011 3,047,904,452 2,351,021,092 N/A
11/01/2011 3,047,834,348 2,374,088,428 23067336
12/01/2011 3,075,162,924 2,399,864,236 25775808
01/01/2012 3,080,739,440 2,424,966,480 25102244
02/01/2012 3,088,191,100 2,476,603,612 51637132
Growth (KB) = Used Current Month - Used Previous Month
Pls let me know if you have any questions.
Best Regards,
Vasanth G
Hi,
You can also run transaction DB02OLD and you will get back your old DB02....
Regards,
Olivier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need to use same Tcode DB02 in newer 6.0 version as follows:
Go to Space --> History --> Database Size History , here you can select period as perday , per week or per month.
Pls confirm , if you are able to locate this path in DB02 to check DB growth report.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.