February 9, 2009 at 10:27 pm
I inherited a db that has 2 index ndbs and 2 data files (1 mdb, 1 ndb of course). Both indexes and the ldf are on a raid 1 array and both data on the same raid 5 array.
Is there any advantage to having multiple files of the same type on the same filegroup on the same array/channel?
Maybe this makes future growth easier?
February 9, 2009 at 10:36 pm
No real advantage.
August 21, 2009 at 4:34 am
Steve Jones - Editor (2/9/2009)
No real advantage.
there are benefits to have multiple files, even in the same file group. depends on your database setup. if the database uses partioning, it can make a difference. you can have multiple read/write operation against the databases, but being actioned against different files, so the I/O's are targeted against the respective files. I know it is the same volume as such, but it can make a difference. Similiar in a way to, how tempdb is recommended to be split into multiple files, 1:1 based on number of cpu's, purely to allow 1 cpu, 1 dedicated tempb file. there are other reasons as well, but these are some of the easiest to explain
A lot of it depends on your setup. to be honest, size of database play a part.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy