| Tibor Karaszi 2002-10-31, 5:23 am |
| > a) What is the maximum size of data file i can have?
32TB
> Is there a limit to the size it can grow?
The max size.
> If it becomes too big will Windows NT be
> able to handle it efficiently?
No real limit that I'm aware of.
> b)IS it better to have 4 data files or its better to
> have only one data file?
>
> Here is what i read in one of the KB article which i
> thought was very intresting.
<snip>
As I mentioned before, that information is incorrect. I would use few files, but more decide on
file size from a practical viewpoint (not performance).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Samir" <samir.pandit@veripsan.com> wrote in message
news:c91001c28032$7b51e540$39e
f2ecf@TKMSFTNGXA08...
> Lets say i have 4 36 GB physical disks in a single RAID
> and this is the only RAID available for DATA files.
>
> a) What is the maximum size of data file i can have?
> Is there a limit to the size it can grow?
> If it becomes too big will Windows NT be
> able to handle it efficiently?
>
> b)IS it better to have 4 data files or its better to
> have only one data file?
>
> Here is what i read in one of the KB article which i
> thought was very intresting.
>
> "File Sizing and Use of AutoGrow
> It is recommended that SQL Server files be sized such that
> there will be at least three equally sized SQL Server
> files per Redundant Arrays of Inexpensive Disks (RAID)
> array and these files should be set at maximum size to
> which they are expected to grow. Use autogrow to cover
> sizing emergencies. Defining three files is helpful for
> speeding up data redistribution if it is determined that
> more I/O processing power is required and a new RAID array
> needs to be brought online."
>
> Any insights will be helpful as i'm gettting confused
> between this KB and the responses.
>
>
|