home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,629 of 19,505   
   Pasi Oja-Nisula to All   
   SAN and sequential reads   
   05 Sep 09 13:24:32   
   
   From: pon@iki.fi   
      
   First of all, I'm from separate data from logs -generation and I know   
   nothing about SAN disks. And that's why I made some tests when we got   
   some more disk space that was allocated from this wonderous SAN.   
   Generally the SAN performance is great, but while measured from sqlio.exe   
   the sequential reads performance was bad when compared to local   
   raid array.   
      
   I wrote the results here:   
   http://seepia.dyndns.org/~pojanisu/raidvssan/raidvssan.html   
      
   If you look at the sequential reads part of the first picture you   
   see what I mean. Does anyone have an explanation (or a guess) why   
   SAN hates sequential reads in this case? Contention, cache or what?   
      
   Pasi   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca