Question Re: Database size in db02 in Technology Q&A

Database size in db02

Former Member — Tue, 10 Jun 2014 04:53:23 GMT

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

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 05:37:08 GMT

Hi Bilal,

see this link usefull for you

Regadrs,

Chandu

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 05:57:30 GMT

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

Re: Database size in db02

S_Sriram — Tue, 10 Jun 2014 05:59:20 GMT

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?

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 06:13:54 GMT

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

Re: Database size in db02

S_Sriram — Tue, 10 Jun 2014 06:29:47 GMT

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

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 06:32:19 GMT

Hi Bilal,

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

you can see no.of files,Total size,

Allocated size-it is actual Db size.

Regards,
Chandu

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 06:39:39 GMT

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

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 06:45:34 GMT

Re: Database size in db02

S_Sriram — Tue, 10 Jun 2014 06:49:39 GMT

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)

Re: Database size in db02

S_Sriram — Tue, 10 Jun 2014 06:55:25 GMT

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)

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 07:13:15 GMT

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

Re: Database size in db02

S_Sriram — Tue, 10 Jun 2014 07:53:13 GMT

Hi Bilal

Can you paste the first page of transaction ST04

Re: Database size in db02

Former Member — Tue, 10 Jun 2014 10:44:11 GMT

Re: Database size in db02

S_Sriram — Tue, 10 Jun 2014 12:52:15 GMT

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