... a single 550GB data file has any inherent problem, the answer is no. But as others have pointed out, depending on various factors, it may be more convenient to have multiple smaller files. Linchi "JTL" wrote: Our production database is currently at 550 GB and growing. Currently, it sits on a single, 550 GB .mdf file. Im quite familiar with many aspects of sql server, ...
... most cases RAID5 is not that good in terms of mixed (read\write) environments. It's better to locate the data files on RAID10 and log files on RAID1 in most cases. -- Ekrem Önsoy "JTL" <jt@clickstreamtech.com> wrote in message news:ejoCgUolIHA.5080@TK2MSFTNGP02.phx.gbl... Our production database is currently at 550 GB and growing. Currently, it sits on a single, 550 GB ....
... Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "JTL" <jt@clickstreamtech.com> wrote in message news:ejoCgUolIHA.5080@TK2MSFTNGP02.phx.gbl... Our production database is currently at 550 GB and growing. Currently, it sits on a ...