create a database with 2 or more files on same drive ?

Does it help if you create a database with 2 or more data files on the same
drive ? Or is it better just to create one especially since its just one
drive ?Hi Hassan,
If it is a single Drive, you could create a single database file.
If you have multiple disk controller then plan for creating multiple data
files one each in each controller. But if your disk I/O is less then you
could create
the file in the sigle drive.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>|||If you can put them on separate drives you might get better performance.
Better yet, if you can separate the .LDF (log) files from the .MDF (data)
physically (separate drives) you'll see an improvement. Spreading the same
database around in separate files on the same drive won't particularly help
performance. I've seen people create separate filegroups on a single drive
in anticipation of moving them to separate drives down the road, however.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23bU%23wYhTFHA.1152@.tk2msftngp13.phx.gbl...
> Does it help if you create a database with 2 or more data files on the
> same
> drive ? Or is it better just to create one especially since its just one
> drive ?
>