Re: Another Filegroup question

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 13:37:06 -0500

I agree with Michael. I would use 2 disks in a RAID 1 for the log files and
add those other two disks to the other Raid 1+0 and place all the files
there. Yes you can get increased performance by placing data and indexes on
separate arrays but probably not as much overall gain from adding more disks
to the Raid 1+0 and separating the logs. 

-- 
Andrew J. Kelly  SQL MVP
"Mardy" <Mardy@discussions.microsoft.com> wrote in message 
news:2B260F96-324A-40A2-9EFE-88B66E85C349@microsoft.com...
> I'm building a reporting server. I have a server with 2 processors, 2 
> drive
> arrays (2 raid 1+0 arrays - 4 disks total of 146 gb each) server with 2 gb 
> of
> memory (negotiating for more). I have about 130 gb of data and a little 
> more
> than half is indexes. One table makes up 50% of the data and indexes. 
> Also, I
> plan to use transactional replication.
>
> I'm considering creating 2 file groups, one on each drive/array and
> separating the indexes from the data. I'm assuming this will yield a
> performance benefit and I'm wondering if I should also create 2 files in 
> each
> filegroup to futher enhance performance but am not sure if this will 
> result
> in further gains.
>
> Thanks
>
> MG

Relevant Pages

  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... available disks and set up I can put the data files on D: ... on RAID 5 which has a greater read performance ... and put the .ldf files (Log files, by their nature, are mostly written ...
    (microsoft.public.sqlserver.setup)
  • Re: Disk Partitioning on exch 2003
    ... > Putting the log files on the same drive partition is not a best ... > really should consider getting some other disks to put the log files. ... same RAID controller. ...
    (microsoft.public.exchange.design)
  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... available disks and set up I can put the data files on D: ... on RAID 5 which has a greater read performance ... and put the .ldf files (Log files, by their nature, are mostly written ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... the idea behind best practice of putting the Log files on a different RAID Array is to dedicate the disk spindles to only one Transaction Log file. ... available disks and set up I can put the data files on D: ... you do not have enough disks to set another RAID1 for your log ...
    (microsoft.public.sqlserver.setup)
  • Re: DC RAID Configuration
    ... If the machine has 6 spindles then OS/Logs go on a hardware mirror, if 10 then they go on a 4 disk hardware based 0+1 RAID. ... Their DIT is only in the teens in size so the disks themselves could be small, you just need many to get the high IOPS that make AD really run smoothly. ... 30 DCs with 2500 users total, unless the environment had a lot of very heavy use AD apps I would likely be ok for even a single mirror for those DCs. ...
    (microsoft.public.win2000.active_directory)