Filegroup - data file question

We just recieved a RAID setup and i would like to know the best setup for my
data files.
We have a 60GB database. What would be the setup on a RAID with 5 disks?My question wasn't on which RAID to select. I understand that portion. My
question was filegroups and data files for my database?
I want to know the purpose of file groups when creating a database.
thanks for the help though.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OpxNjNrfDHA.2352@.TK2MSFTNGP12.phx.gbl...
> You still didn't say anything as to how you will use it, how many
> transaction etc. 50% writes is nothing to sneeze at but a lot depends on
> how large the updates are and how many per second. If your only doing a
> handful a second then it won't matter as much as if your doing 1000 a sec.
> A Raid 5 might get by on the lower end but if you are going to heavily use
> the system then you might want to consider a RAID 0+1 or 1+0.
Unfortunately
> you only have 5 disks and that would leave just a 4 disk Raid with only 2
> usable as far as size goes. You didn't say how large your drives are but
if
> they are only 36GB or so then this would not be enough space for a Raid
0+1
> or 1+0. Your only option may be to use Raid 5.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Richard King (BSM)" <google@.walkersca.com> wrote in message
> news:OcausAnfDHA.956@.TK2MSFTNGP09.phx.gbl...
> > 70%-50% Reads advantage
> >
> > OS will be on own drive as well as logs.
> >
> >
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > news:OpatO9lfDHA.2152@.tk2msftngp13.phx.gbl...
> > > How are you going to use it? How many transactions, writes vs reads,
> > large
> > > or small selects etc. Will the logs be on a separate drive array? Is
> the
> > > OS on a separate array as well?
> > >
> > > --
> > >
> > > Andrew J. Kelly
> > > SQL Server MVP
> > >
> > >
> > > "Richard King (SCA)" <google@.walkersca.com> wrote in message
> > > news:OyaVo9kfDHA.3284@.tk2msftngp13.phx.gbl...
> > > > We just recieved a RAID setup and i would like to know the best
setup
> > for
> > > my
> > > > data files.
> > > >
> > > > We have a 60GB database. What would be the setup on a RAID with 5
> > disks?
> > > >
> > > >
> > >
> > >
> >
> >
>|||OK. Filegroups are mainly used to segregate data for one of two reasons.
One is for backup reasons. If you have a very large database you can do
backups at the filegroup level so you don't have to do it all at once.
Usually for terabyte range dbs. Another is that it allows you to place
database objects (tables and indexes) on different drives or drive array's.
In your case you will only have 1 array for the data and the db won't be
that large. You probably won't gain much by having multiple filegroups.
Again on larger db's and very heavy usage one it may be beneficial to have
multiple files to allow lots of parallel threads to read them at once. But
you generally need the higher level hardware to take advantage of that.
BooksOnline has some more details on Files and Filegroups that you may want
to take a look at.
--
Andrew J. Kelly
SQL Server MVP
"Richard King (BSM)" <google@.walkersca.com> wrote in message
news:OYe6MrwfDHA.616@.TK2MSFTNGP11.phx.gbl...
> My question wasn't on which RAID to select. I understand that portion.
My
> question was filegroups and data files for my database?
> I want to know the purpose of file groups when creating a database.
> thanks for the help though.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OpxNjNrfDHA.2352@.TK2MSFTNGP12.phx.gbl...
> > You still didn't say anything as to how you will use it, how many
> > transaction etc. 50% writes is nothing to sneeze at but a lot depends
on
> > how large the updates are and how many per second. If your only doing a
> > handful a second then it won't matter as much as if your doing 1000 a
sec.
> > A Raid 5 might get by on the lower end but if you are going to heavily
use
> > the system then you might want to consider a RAID 0+1 or 1+0.
> Unfortunately
> > you only have 5 disks and that would leave just a 4 disk Raid with only
2
> > usable as far as size goes. You didn't say how large your drives are
but
> if
> > they are only 36GB or so then this would not be enough space for a Raid
> 0+1
> > or 1+0. Your only option may be to use Raid 5.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Richard King (BSM)" <google@.walkersca.com> wrote in message
> > news:OcausAnfDHA.956@.TK2MSFTNGP09.phx.gbl...
> > > 70%-50% Reads advantage
> > >
> > > OS will be on own drive as well as logs.
> > >
> > >
> > >
> > > "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> > > news:OpatO9lfDHA.2152@.tk2msftngp13.phx.gbl...
> > > > How are you going to use it? How many transactions, writes vs
reads,
> > > large
> > > > or small selects etc. Will the logs be on a separate drive array?
Is
> > the
> > > > OS on a separate array as well?
> > > >
> > > > --
> > > >
> > > > Andrew J. Kelly
> > > > SQL Server MVP
> > > >
> > > >
> > > > "Richard King (SCA)" <google@.walkersca.com> wrote in message
> > > > news:OyaVo9kfDHA.3284@.tk2msftngp13.phx.gbl...
> > > > > We just recieved a RAID setup and i would like to know the best
> setup
> > > for
> > > > my
> > > > > data files.
> > > > >
> > > > > We have a 60GB database. What would be the setup on a RAID with 5
> > > disks?
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>