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