February 8, 2013 at 6:41 am
Hi all,
Could someone explain what happens when a database has 4 data files all on the same filegroup each having a different file size.
I thought that unless you create filegroups.. its not possible to choose what data file things are saved to.
Hope someone can shed some light!
February 8, 2013 at 6:57 am
To spread the IO load, but you would usually have them all sized the same.
February 8, 2013 at 7:01 am
n00bDBA (2/8/2013)
I thought that unless you create filegroups.. its not possible to choose what data file things are saved to.
Correct.
As for why the files are different sizes, they were likely created that way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2013 at 9:07 am
hey thanks for the replies..
Could anyone expand a little bit.
How is data put into files? random?, round robin?, fill one then move on to the next?
Ive seen a lot of 3rd party app databases that have it.. They always have named .ndf like they relate to a certain part of the database. It just part of the art of making your app look fancy to the unsuspecting eye?
Very curious.
Thanks
February 8, 2013 at 10:03 am
Data files other than the primary by convention get the extension .ndf
The fill method it proportional fill. You can google for the intricate details if you wish
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply