Re: Separate Data and Log files

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Wed, 5 Jan 2005 19:38:13 -0500

It is quite possible that a SAN can mask the need to separate the files due
to large amounts of cache. But that still depends on what you are doing, how
many transactions etc. I have seen SAN's in which the files were not
segregated and there were performance issues but it all depends. 

-- 
Andrew J. Kelly  SQL MVP
"Tom W" <Tom W@discussions.microsoft.com> wrote in message 
news:DE458441-263C-43AF-9A17-E8C719283AD9@microsoft.com...
> Is there a documented information about separating the data and log files
> pertaining to physical disk layouts.  How much relevance is this
> documentation with newer SAN technologies where there are large buffer
> caches.  Because my understanding is that the SAN units notifies the 
> server
> that the data is written to disk when in actuality it is still in cache
> waiting to be written to disk.
>
> Tom

Relevant Pages

  • Re: lseek/write
    ... opposed to not using lseek. ... in cache and with it, ... When I call fsync i flush the cache to disk but only the new ... There's really no reason they should be, depending on how your SAN is ...
    (comp.os.linux.development.system)
  • Re: Exchange 2007 SCC Cluster - Slow Failover
    ... Doesn't surprise me a bit. ... A SAN is not a panacea for performance issues, ... the SAN and the disk layout? ... cache to a copy of the database that won't be used". ...
    (microsoft.public.exchange.admin)
  • Re: Separate Data and Log files
    ... Most of the modern SAN vendors (EMC, Hitachi, ... > data cache hit and cpu utilization of aroun 40%. ... > Does Microsoft have anything documented or maybe even some SAN vendor? ... >>> pertaining to physical disk layouts. ...
    (microsoft.public.sqlserver.setup)
  • Re: How accurate are AIX disk reporting metrics with a SAN?
    ... mean anything on a SAN? ... Its looks like your focusing on the data distribution on the disk. ... answered only by you since i do not know your SAN configuration, ... configure the cache on the SAN to your needs. ...
    (comp.unix.aix)
  • RE: Write Caching
    ... I have seen FTDISK events being reported even for SAN volumes. ... In other words the cache between ... > the NODES Raid Controller cards has no way to update. ... >> PERC 4DC are in cluster mode and by default set to write through caching. ...
    (microsoft.public.windows.server.clustering)