on 12-29-2007 12:39 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.