locked
Usage of Files In SAN Unit. RRS feed

  • Question

  • Hello, I have some Questions, if any one knows plz reply me,

    1. Are file groups beneficial when the data files will be on one SAN unit ?

    2.  Since our Production database has growth of 1 TB What should we set the initial space at for our production database?

    3. Explain how space is being utilized with file groups on a database?

    Thanks in advance

    Tuesday, September 14, 2010 2:10 PM

Answers

  • Hi,

    Spreading data files across different file group will definitely improve SQL server performance but ensure to place different LUN. For example, if you have  few tables are frequently used by application, moving those tables to different file group will improve performance. Also, move index files to different file groups.

    Check this file group article .

     

    2.  Since our Production database has growth of 1 TB  What should we set the initial space at for our production database?

    Since your database size is already reached 1TB , there is no need to set initial space size. If you are looking for space issue solution, try to check free space in database and shrink as possible as. But shrinking wont to resolve your issue because it will reach same size again if your transaction is very high.



    Ramesh S
    www.sequalserver.com
    • Proposed as answer by Tom Li - MSFT Thursday, September 16, 2010 8:07 AM
    • Marked as answer by Tom Li - MSFT Wednesday, September 22, 2010 8:29 AM
    Wednesday, September 15, 2010 6:25 AM

All replies

  • Hi,

    Spreading data files across different file group will definitely improve SQL server performance but ensure to place different LUN. For example, if you have  few tables are frequently used by application, moving those tables to different file group will improve performance. Also, move index files to different file groups.

    Check this file group article .

     

    2.  Since our Production database has growth of 1 TB  What should we set the initial space at for our production database?

    Since your database size is already reached 1TB , there is no need to set initial space size. If you are looking for space issue solution, try to check free space in database and shrink as possible as. But shrinking wont to resolve your issue because it will reach same size again if your transaction is very high.



    Ramesh S
    www.sequalserver.com
    • Proposed as answer by Tom Li - MSFT Thursday, September 16, 2010 8:07 AM
    • Marked as answer by Tom Li - MSFT Wednesday, September 22, 2010 8:29 AM
    Wednesday, September 15, 2010 6:25 AM
  • For the VLDB like you will have,  file group is a better management unit even if all file groups/files are on the same disk array. We can backup/restore file group, check integrity on file group DBCC CHECKFILGROUP etc.

    So it is better to split large tables across file groups.  If all tables are in one file group, these maintenance will take long time.

     

    Wednesday, September 15, 2010 12:22 PM
  • Thanks phe and ramesh..its really helpful to me......
    Thursday, September 16, 2010 1:58 PM