April 7, 2005 at 9:33 am
I have mostly small databases, but I have a couple that are starting to grow (2, 4, 5 and 50 GB).
Right now they all have one DB file and one LOG file. I am intrested in what other DBA's use for when to break up the DB into multiple files.
April 8, 2005 at 11:03 am
My rule of thumb is 1 and 1 for databases under 100-200 Gb. After that, it all depends ... on size, storage, activity, application availability ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 8, 2005 at 11:06 am
Generally, this is more complex than just adding a file group. The rule of thumb I would use, if, for performance, you need to add more then do it. Meaning that if you need to physically (on different drives or RAID arrays) split hte physical data tables and indexes, then add another file group to another drive. I've not seen large benefit to creating an additional file group on the same drive, unless you're trying to create 'contiguous' space.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply