Database size in db02

[Former Member]

Hi,

I want to check the database size and growth/year,month,week.

Which columns I should add up to get the actual database size in

db02--> space --> History--> Database size History.

Regards

[Sriram2009]

Hi Bilal

1.  In same transaction code DB2 you can find the information Day / week / Month wise.

2. Which Database are you using ? either DB2 or some other database?

BR

SS

[Former Member]

We are using SQL Server 2012.

in db02-->Space-->History-->Database size History

I get many columns like : DB, DB Size,AllocSpace, AllocSpace, Reserved, Num.tabs,

Data Size(KB), Num.ind, index, Unused and Num procs.

Here i am little confused where i can get the actual database size, coz in DB Size column, it shows the space which is allocated for the database, not the actual size of database. Do i need to add value of column Data Size(KB) and Index to get the actual size of database?

Regards

Bilal

[Sriram2009]

Hi Bilal

1. You can use transaction either DB02 or ST04 for MS Sql DB.

2. in that you can find the information Daily / Week / Month wise kindly refer the screen shot

3. DB overall soze you can view in the first page of either DB02 or ST04 on MS Sql DB

BR

SS

[Former Member]

Hi Bilal,

goto-> db02 ->space->overview->Data

you can see no.of files,Total size,

Allocated size-it is actual Db size.

Regards,
Chandu

[Former Member]

Chandu,

I can see the database size there, but i want to check the growth in each three months. 

SS: The DB Size gives me the space allocated for the database, I have same value for this column in for last one year.

I am confused in Data Size(KB) and index column to calculate the growth, whether I should add these columns or Data Size(KB) alone gives me the growth?

Regards

Bilal

[Former Member]

[Sriram2009]

Hi Bilal

1.  What i am mention the screen shot you can find the tab " DB Size" that is the database size of your DB.

2. In same windows you can select the radio button "Per Month" you can find the month wise db size with that you can calculate the data growth (Month 1 - Month 2 = db growth)

BR

SS

[Sriram2009]

Hi Bilal

You may created number of physical data files(number of physical container) in MS Sql DB size & over all index size

In that screen first tab "DB Size" this is over all the Database size (Data + index + log)

BR

SS

[Former Member]

SS: In DB Size column, I cannot calculate the difference as you can see in the below SS.

[Sriram2009]

Hi Bilal

Can you paste the first page of transaction ST04

BR

SS

[Former Member]

[Sriram2009]

Hi Bilal

Thanks for your info

1. Just clear the transaction log and run the DB check during off peak time as mention in the SAP Note 142731 - DBCC checks of SQL server

2. After completion DB check you have to do the DB shrink. there free space are available in your db  kindly refer the screen shot

if possible you can enable the option at DB level

3. Every day once the backup completed you have start the transaction log truncate backup in MS Sql DB

Check this and let us know the status

BR

SS

[Former Member]

Hi Bilal,

see this link usefull for you

Regadrs,

Chandu

[Former Member]

Hi Chandu,

But I cannot see the navigation in my system which is mentioned there in the link like

"On the screen click on the " space statistics" button, it will show you total db size,free space,daily weekly monthly DB growth"

"Once you are on Months tab ,you will se the following detaisl ..."

"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."

None of the above i can find in my case, we are on ECC6. Please suggest

REgards

Bilal