Skip to Content
author's profile photo Former Member
0
Former Member

query regarding database size

Posted on Oct 16, 2006 at 11:01 AM 14 Views

hi,

( sap 4.7c + sql server 2000 (Module:sd/mm/fi )

( data : 1 & half year - no BI )

our database size is around 50 GB

and log size is around 30 GB

I doubt that something is wrong.

can anyone explain to me what is right and

what action one should take on this type of scenario.

thanks in advance

raj

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 05:03 AM
    2

    thanks Marcin,

    you are right. it is 'auto grow'.

    i am planning to set 10% of size.

    if i apply shrink database today , everytime i have to apply the same ?.

    is there any other option also?.

    everyone is having such a large log size (30 gb) compare to databse size (50 gb)?.

    regards

    raj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 18, 2006 at 06:39 AM

      Hi Raj,

      My database size is about 30GB (3 years of usage) and log file is about 12GB.

      My database settings (recomendent by SAP and Early watch) are:

      I shrinked database to minimum size and set following settings:

      Database (mdf and ndf):

      - growth activated: checked

      - growth not restricted: checked

      - next step possible: checked

      - next step size: 60MB

      tempdb and log file:

      - growth activated: checked

      - growth not restricted: checked

      - next step possible: checked

      - next step size: 10%

      Regards,

      Marcin Gajewski

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2006 at 05:17 PM
    0

    Hi Raj,

    First, check in Enterprise Manager properties of the database. Maybe Your database have 'auto grow' enabled.

    That may explain size of database.

    You may shrink database too. Empty space allocated in *.mdf, *.ndf, *.ldf files will be truncated.

    Regards,

    Marcin Gajewski

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 10:54 AM
    0

    thanks Marcin - full point

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2006 at 05:17 PM
    0

    Hi Raj,

    This is an amazing statistic to me. How may users do you have?

    ( sap 4.7c + sql server 2000 (Module:sd/mm/fi )

    ( data : 1 & half year - no BI )

    our database size is around 50 GB

    and log size is around 30 GB

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 04:52 AM
    0

    hi cjh,

    we have more than 50 users. we have 6 plant...

    raj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.