Skip to Content
avatar image
Former Member

database shows growth very quickly

Hi experts,

I have BW system , the last week I upgraded it , but the data base grown quickly.

what do I do in the system ?

Regards

Graciela

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 07, 2010 at 06:40 PM

    this is normal,

    an upgrade has an impact on the database usage, especially during the upgrade.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      please provide us a few numbers before and after the upgrade. A DB growing from 50 GB to 100 GB could be normal. Growing from 500 GB to 1 TB is rather unusual.

      Sven

  • avatar image
    Former Member
    Sep 08, 2010 at 12:26 PM

    Graciela,

    As indicated this is common.

    You should be able to use the SQL Server management studio to shrink the database down and remove any excess empty space. I would suggest that you use the backup function first - it is quite possible that it won't allow you to run shrink until you have carried oiut a full backup. You won't want to do this during prime working hours as it will impact performance.

    If you don't have sufficient disk space to complete the backup process, then you can direct the backup to create the backup file elsewhere, say on a network or external drive.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Eric Brunelle

      Looks normal to me as well. Please check in Tx DBACOCKPIT how much space is actually allocated. It could be that you have a lot of free space in your database.

      maybe you forgot to delete old PSAPE6** tablespaces? this is clearly mentioned in the upgrade guide.

      I don't think so. Eric, it's SQL Server 😉

      Regards,

      Sven