{"id":883,"date":"2006-01-15T12:00:00","date_gmt":"2006-01-15T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=883"},"modified":"2006-01-15T12:00:00","modified_gmt":"2006-01-15T12:00:00","slug":"windows-orion-numbers","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/01\/15\/windows-orion-numbers\/","title":{"rendered":"Windows ORION Numbers"},"content":{"rendered":"

Prompted by Jeff Moss’ blog<\/a>, I decided to use ORION<\/a> to measure the performance of various I\/O configurations I’m testing for the upcoming Hotsos presentation<\/a>. I’ve already blogged about the Linux results<\/a> on a couple of configurations but I’m still tempted to include a Windows Laptop test (although I haven’t decided yet). To that end, I’ve been playing around with the Windows version of ORION today, using XP Professional, SP2.<\/p>\n

I ran into a few problems. The first was that, like Jeff, I didn’t have any raw partitions or volumes for the test and didn’t fancy creating any on my main laptop. So I was restricted to testing on files. I initially tried to test a collection of eight Powerpoint files, so my simple.lun file looked like this. (The files themselves are just a variety of presentations)<\/p>\n

C:\\TEMP\\1.PPTC:\\TEMP\\2.PPTC:\\TEMP\\3.PPTC:\\TEMP\\4.PPTC:\\TEMP\\5.PPTC:\\TEMP\\6.PPTC:\\TEMP\\7.PPTC:\\TEMP\\8.PPT<\/pre>\n
I picked Powerpoint files because Jeff had found that he could only use MS Office files and these were some of the biggest. I ran the test using the following command. (In fact, this is the command I used for all of the following tests – I just edited the contents of simple.lun each time)<\/p>\n
orion -run simple -testname simple -num_disks 1<\/pre>\n
and it seemed to work okay for a few minutes before failing with the following error.<\/p>\n
ORION: ORacle IO Numbers -- Version 10.2.0.1.0Test will take approximately 9 minutesLarger caches may take longer
<\/p>storax_aiowait: IO returned an error 27070lun_aiowait: storax_aiowait failed.rwbase_run_test: rwbase_reap_req failedrwbase_run_process: rwbase_run_test failedrwbase_rwluns: rwbase_run_process failedorion_thread_main: rw_luns failedTest error occurredOrion exiting<\/pre>\n
I think the 27070 is a generic Windows i\/o error. By a process of elimination (otherwise known as faffing around) I managed to get it to work with only one file, with the following results.<\/p>\n
Maximum Large MBPS=18.27 @ Small=0 and Large=1Maximum Small IOPS=231 @ Small=2 and Large=0Minimum Small Latency=4.43 @ Small=1 and Large=0<\/pre>\n
Which are stunning. So good, in fact, that I didn’t believe them for more than a few seconds. The hard disk in a cheap laptop is unlikely to be producing nearly double the number of IOs per second of even a previous generation U160 SCSI drive :-<\/p>\n
Maximum Large MBPS=25.65 @ Small=0 and Large=2Maximum Small IOPS=138 @ Small=4 and Large=0Maximum Small Latency=8.92 @ Small=1 and Large=0<\/pre>\n
Then it occurred to me that testing a tiny 2Mb file is hardly a useful test of drive performance. Looking around for a bigger file, I figured I should try one of the database files!<\/p>\n
C:\\oracle\\product\\10.1.0\\oradata\\orcl\\TEST_DATA01.DBF<\/pre>\n
Which worked fine and seems like the best type of file to use, particularly if I had something bigger than this 3Gb example. Here are the final results.<\/p>\n
Maximum Large MBPS=17.52 @ Small=0 and Large=1Maximum Small IOPS=79 @ Small=5 and Large=0Minimum Small Latency=14.21 @ Small=1 and Large=0<\/pre>\n
They look more sensible to me when compared to the (old PC) single IDE Linux example<\/p>\n
Maximum Large MBPS=14.46 @ Small=0 and Large=1Maximum Small IOPS=46 @ Small=5 and Large=0Maximum Small Latency=22.96 @ Small=1 and Large=0<\/pre>\n
I still think the utility is likely to work more effectively on unused drives rather than a few files.<\/p>\n","protected":false},"excerpt":{"rendered":"
Prompted by Jeff Moss’ blog, I decided to use ORION to measure the performance of various I\/O configurations I’m testing for the upcoming Hotsos presentation. I’ve already blogged about the Linux results on a couple of configurations but I’m still tempted to include a Windows Laptop test (although I haven’t decided yet). To that end,… Continue reading Windows ORION Numbers<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-883","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":898,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/28\/orion-numbers-and-other-bits-and-pieces\/","url_meta":{"origin":883,"position":0},"title":"Orion Numbers and other bits and pieces","date":"November 28, 2005","format":false,"excerpt":"Prompted by Jeff Moss' blog, I've been trying out Orion on a couple of servers. I've blogged about it over on the ISP4400 blog. (Actually, I've only just realised that hosting the blog html myself probably means I can't use permalinks to individual blog entries. Hopefully the ISP4400 blog has\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1392,"url":"http:\/\/orcldoug.com\/blog\/2008\/03\/18\/paste\/","url_meta":{"origin":883,"position":1},"title":"Paste","date":"March 18, 2008","format":false,"excerpt":"[As part of the occasional series on small but useful Unix commands ...]I've always loved Unix and vi and despair at those who prefer to faff around on Windows trying to edit files with an operating system and editors that, yes, are much more friendly but are hopelessly limited. The\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1212,"url":"http:\/\/orcldoug.com\/blog\/2007\/02\/23\/orasrp\/","url_meta":{"origin":883,"position":2},"title":"OraSRP","date":"February 23, 2007","format":false,"excerpt":"While working on the PX paper for Hotsos, I've been trying to show the same issue using different tools that people might have available to them and struggled to get OraSRP working on Solaris 10. From digging around the net I started to realised that the Python distribution included in\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":983,"url":"http:\/\/orcldoug.com\/blog\/2005\/03\/13\/the-dangers-of-windows\/","url_meta":{"origin":883,"position":3},"title":"The Dangers of Windows","date":"March 13, 2005","format":false,"excerpt":"The thing is, I've read all of the articles about viruses, worms, adware and so on (and I've had my browser redirected a few times) but you never really think the worst will happen to you.Today I spent 5 hours trying to fix my daughters PC, which has become seriously\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":926,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/24\/intel-isp4400\/","url_meta":{"origin":883,"position":4},"title":"Intel ISP4400","date":"October 24, 2005","format":false,"excerpt":"I've wanted to carry on investigating parallel execution for a while but, unless you happen to be working on a reasonably large data warehouse with a few spare test environments kicking around, it's difficult. Without wishing to reopen the whole debate about the value of single user test scripts (which\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":967,"url":"http:\/\/orcldoug.com\/blog\/2005\/07\/25\/a-small-follow-up\/","url_meta":{"origin":883,"position":5},"title":"A small follow-up","date":"July 25, 2005","format":false,"excerpt":"From a previous blog entry :-\"... I noticed that the slave trace files are appearing in user_dump_dest. This is with 9.2.0.1.0 on Windows XP Home. I'm using 9.2 because I want to see the discrete SQL statements that the slaves are processing. So, just an interesting anomaly from what I've\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=883"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/883\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}