tag:blogger.com,1999:blog-2173119910600284569.post6605874314531288524..comments2024-02-06T04:58:09.639-05:00Comments on Kendal Van Dyke: Disk Performance Hands On: Series IntroductionUnknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2173119910600284569.post-32734577506205248002009-07-28T13:23:12.290-04:002009-07-28T13:23:12.290-04:00Kendal,
Thanks for sharing your methodology and r...Kendal,<br /><br />Thanks for sharing your methodology and results. Shows the importance of actually benchmarking and comparing possible configurations before you decide what route to take.<br /><br />Thanks,<br /><br />MattAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-27500341298142989242009-07-13T07:25:53.790-04:002009-07-13T07:25:53.790-04:00Here's an addition regarding Solid state drive...Here's an addition regarding Solid state drives (SSD)<br /><br />http://sqlblog.com/blogs/joe_chang/archive/2009/07/01/why-have-we-not-seen-tpc-c-and-tpc-e-benchmarks-using-ssd-storage.aspxALZDBAhttp://www.sqlservercentral.comnoreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-60957401465352480862009-04-07T11:49:00.000-04:002009-04-07T11:49:00.000-04:00Great piece Kendal. I can see many hours went int...Great piece Kendal. I can see many hours went into it. I was just wondering if you ever got round to testing a configuration with a 128KB stripe size and 128KB partition offset? Given the geometry of partition alignment I would be curious to see the results. Thanks again.Christiaannoreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-71719673545447616032009-02-18T23:10:00.000-05:002009-02-18T23:10:00.000-05:00Oh, yeah, block alignment is definitely important ...Oh, yeah, block alignment is definitely important in a caching SAN environment. And RAID levels can still have some effect as well, but not anywhere near as much as other factors.Stephen Fosketthttps://www.blogger.com/profile/05969630798623133995noreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-43672376976041301092009-02-18T22:21:00.000-05:002009-02-18T22:21:00.000-05:00Stephen, thanks for your positive comments. You ar...Stephen, thanks for your positive comments. You are correct, these tests were performed against local storage and DASD. SANs are a different beast, though from what I understand partition offset still needs to be taken into consideration to achieve optimal performance.Adminhttps://www.blogger.com/profile/10237600176486018239noreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-70578957257772599572009-02-16T09:19:00.000-05:002009-02-16T09:19:00.000-05:00It seems part 2 only loads a blank page :(It seems part 2 only loads a blank page :(Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-20773335134567186502009-02-13T09:48:00.000-05:002009-02-13T09:48:00.000-05:00This is a great series! As an enterprise storage p...This is a great series! As an enterprise storage professional, it's nice to see folks in other areas looking this deep into storage questions.<BR/><BR/>One thing I want to point out, though, is that intelligent caching disk arrays found in many larger data centers (think EMC, IBM, HDS, HP, NetApp, etc) throw these results in the trash however. Each has its own idiosyncrasies, to be sure, but none is as clear-cut as the basic RAID you're experimenting with.<BR/><BR/>I've had many a SQL DBA argue that he couldn't run on RAID-5 because of his experiences with low-end RAID systems. But after demonstrating the performance of an enterprise array he definitely changed his tune! I'm no cheerleader, just a realist!<BR/><BR/>Thanks again for your work and posts!Stephen Fosketthttps://www.blogger.com/profile/05969630798623133995noreply@blogger.com