How to choose file structure on SQL database?

I created MDF file and LDF for one database on SQL server 2000.
I need to create more DNF files on other 5 logical drives for this datanase.
All these logical drives are located in SAN storage configured with RAID10.
Should I create one NDF on each logical drive OR create multiple DNF on each
logical drive?
Which way is better for performance?
Thanks,Mike
What is DNF files? Is it NDF? Have you monitor your SQL Server to make such
decision?
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,|||Mike Torry wrote:
> I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this datanase.
> All these logical drives are located in SAN storage configured with RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on each
> logical drive?
> Which way is better for performance?
> Thanks,
Hi,
If it's logical drives rather than physical drives, it won't help you a
lot to split the files on several drives. If you want to increase
performance, the data will have to placed on different physical spindles
and also preferably on different controllers (in most cases you'll just
have your MDF files disks on one controller and your ldf files disks on
a second controller). If you have any influence on hos your SAN is being
configured, you should also consider have more spindles in an array
rather than having many arrays. Depending on the usage of your database
it will give a better performance to have more spindles to read from
rather than splitting the load on several arrays/disks.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Hello,
Probably you should be talking about NDF files. Since it is SAN just try
creating the database in a Single Logical drive (1 logical drive for MDF
and another for LDF) and see how database performs. See the I/O queue length
counter in perfmon and seee how well it goes.
If it quue length is always <=1 then you are good. I have the similar
environemnt and I have created database based on this strategy.
I will recommend you to keep the files in multiple drives if you have
multiple controllers running. Otherwise even if you create files
in multiple logical drives you will not get any performance improvements.
Thanks
Hari
"Mike Torry" <MikeTorry@.discussions.microsoft.com> wrote in message
news:FDBA14B3-18FC-4723-8D73-08A46ECD921C@.microsoft.com...
>I created MDF file and LDF for one database on SQL server 2000.
> I need to create more DNF files on other 5 logical drives for this
> datanase.
> All these logical drives are located in SAN storage configured with
> RAID10.
> Should I create one NDF on each logical drive OR create multiple DNF on
> each
> logical drive?
> Which way is better for performance?
> Thanks,