Skip to Content

Optimal number of "ACTIVE" Datafiles -

Hello,

Current situation :

Datafile SIZE Next G File Name File Size Limit

PMPDATA1 344,000 0 M:\PMPDATA\PMPDATA1.mdf 343001

PMPDATA2 265,000 0 M:\PMPDATA\PMPDATA2.ndf 265001

PMPDATA3 266,000 0 M:\PMPDATA\PMPDATA3.ndf 266001

PMPDATA4 285,000 2,000 M:\PMPDATA\PMPDATA4.mdf no limit

PMPDATA5 285,000 2,000 M:\PMPDATA\PMPDATA5.mdf no limit

PMPDATA6 285,000 2,000 M:\PMPDATA\PMPDATA6.mdf no limit

We used to have 3 datafiles. When the disk that they were on was full

(I stopped their growing) AND

created 3 more files on a different disk.

Then we put all 6 files on NEW disk But left the first 3 files with

File Size Limit.

NOW , That all 6 files are almost the same size I want to make ALL 6

files grow with NO limit.

QUESTION:

What is the correct practice between : (Assuming they ALL stay on same

Drive)

- Allow All 6 files to grow (Reomve the file Size limit on first 3

files) OR

- Leave the current situation (Only 3 files continue to grow)

Thanks a lot,

Edited by: Moshe-Eliashar Yerushalmy on Dec 12, 2011 2:46 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Dec 12, 2011 at 02:02 PM

    Hi,

    Check below thread:

    sql-database-size-in-dbacockpit

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 02:15 PM

    > QUESTION:

    > What is the correct practice between : (Assuming they ALL stay on same

    > Drive)

    > - Allow All 6 files to grow (Reomve the file Size limit on first 3

    > files) OR

    > - Leave the current situation (Only 3 files continue to grow)

    I would go for utilizing all 6 files equally allowing them to grow with no limit.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2011 at 09:12 PM

    Hello Moshe,

    The following whitepaper has valuable information:

    http://www.sdn.sap.com/irj/sdn/mss?rid=/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548c65

    Regards,

    Eduardo Rezende

    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.