Re: Raw Disk still preferred for 11.5?

On 6 Oct, 19:09, InDeep <ind...@indeep.com> wrote: > If you are on a SAN, raw disk is really not necessary, it > may yield a small performance gain, but it may also create > extra work for you.  If performance is critical you might > want to do raw disks, but I have been seeing and hearing > only around 10% improvement.  I'd actually recommend against > raw disks unless you are doing some kind of major > transactions that the extra work to used them gives you the > small amount of extra speed. > > The other advantage to using cooked files is the ease of > doing backups.  If you use raw disks you will be at the > mercy of the database engine to do backups.  If you stay > with cooked files you can simply copy partition files after > shutting down the engine.  Again this depends a lot on your > needs and availability. > The whole idea of online is that you can take online backups and not have to shut down the server to take backups... > Remember, your database is as fast as your hard drives, so > if you have 15K drives vs 10K drives, you have significant > speed differences. > > What speed are your drives? > > > > Laurie Gustin wrote: > > I am setting up a new set of servers that will utilize the SDS > > capabiltiy of IDS 11.5 and just want to make sure that raw disk space is > > still the best way to go. > > > I plan to have at least 3 SDS servers. > > >  SLES 10.2 > >  4 processors per server > >  32 GB ram per server > > > Thanks in advance for your comments. > > > Laurie > > > Laurie Gustin > > IT Programmer Analyst > > Department of Public Safety > > lgus...@utah.gov <mailto:lgus...@utah.gov> > > 801-965-4410- Hide quoted text - > > - Show quoted text -