cancel
Showing results for 
Search instead for 
Did you mean: 

database storage space in BW

Former Member
0 Kudos

Hi,

Our BI dataabase growing everyday 4 - 5 GB, but actually our source system database size ECC - 700GB and BI database size 1200GB.We are not sure how it growing irrespective of source system.We are using BI7.0, MS SQL

Is there a way we can restrict the datase growth.Appricite for your inputs.

- Thanks in advance

Kristne

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Thanks for your suggsions.We have deleted few PSA tables data which consumes more space.But after deleting i still see the space consumed.It supposed to be free the harddisk space.

Do i need to do some settings after that to get more space.

Kristene

Former Member
0 Kudos

Hi,

You have to reorgnaise the tables or complete database.

Regards

Subhash

Former Member
0 Kudos

Hey Kristne,

There are several ways to restrict the DB grow,

First please follow according to:

  • SAP Note 706478 Preventing Basis tables from increasing considerably

The next step is to find the most largest table and growing,

you can do this in transaction DB02:

'DB Analysis' - 'Top n largest tables' and ' Top n modified

Now, you would be able to see which tables are growing,

if this table contains application data, than the growing must be

due to the growing in the ECC, and that's normal, otherwise,

you would have to check this specific table (and how you should reorganize this table)

p.s

you can also find the lastest tables by executing the following SQL:

select [reserved (MB)], [unused (MB)], [Table Rows],

right(space(16)left(user_name(o.uid),16),16)'.' as [Schema], left(object_name(i.id), 32) as [Table]

from (

select top 50

left(convert(char(18),convert(money,(sum(reserved)/128)),1),15) as [reserved (MB)],

left(convert(char(18),convert(money,((sum(reserved)-sum(used))/128)),1),15) as [unused (MB)],

left(convert(char(18),convert(money,(max(convert(int,convert(char(11),rows))))),1),15) as [Table Rows],

id

from sysindexes where indid in (0,1,255)

group by id

order by [reserved (MB)] desc, [Table Rows] desc) as i

inner join sysobjects o

on i.id = o.id

order by [reserved (MB)] desc, [Table Rows] desc