Re: Netapps vs EMC -- db file scattered read

jmourik_at_yahoo.com wrote:

> Yes, a lot of "it depends" for sure... btw, netapp is nas attached, emc
> with fibrechannel.
> Just as fun facts some statspack data:
>
> Before (NETAPP)...
> SNAPTIME EVENT WAIT_MS WAITS
> 01/18/2005 08:00:39 db file sequential read 5 134732
> 01/18/2005 08:15:05 db file sequential read 5 541650
> 01/18/2005 08:30:22 db file sequential read 18 269556
> 01/18/2005 08:45:55 db file sequential read 18 287182
> 01/18/2005 09:00:22 db file sequential read 11 403432
> 01/18/2005 09:15:51 db file sequential read 15 506866
> 01/18/2005 09:30:16 db file sequential read 15 481645
> 01/18/2005 09:45:47 db file sequential read 8 776100
> 01/18/2005 10:00:11 db file sequential read 7 800140
>
> SNAP_TIME PART NAME ELAPSED
> PERCENTAGE
> ---------------- ------------- ------------------------- --------
> ----------
> 01/18 09:00:22 Wait Time db file scattered read 1:38:48 39.49
> 01/18 09:00:22 Wait Time db file sequential read 1:25:52 34.32
> 01/18 09:00:22 Service Time Other cpu 0:20:38 8.24
> 01/18 09:00:22 Wait Time buffer busy waits 0:13:38 5.45
> 01/18 09:00:22 Wait Time PL/SQL lock timer 0:09:34 3.83
> 01/18 09:00:22 Wait Time enqueue 0:06:22 2.55
> 01/18 09:00:22 Service Time recursive cpu usage 0:04:32 1.81
> 01/18 09:00:22 Wait Time latch free 0:02:23 0.95
> 01/18 09:00:22 Service Time parse time cpu 0:01:37 0.64
> 01/18 09:00:22 Wait Time SQL*Net more data to clie 0:01:07 0.45
>
>
> After (EMC):
> SNAPTIME EVENT WAIT_MS WAITS
> 01/25/2005 08:00:47 db file sequential read 3 142288
> 01/25/2005 08:15:08 db file sequential read 2 328645
> 01/25/2005 08:30:32 db file sequential read 2 124573
> 01/25/2005 08:45:55 db file sequential read 2 137748
> 01/25/2005 09:00:18 db file sequential read 1 629697
> 01/25/2005 09:15:39 db file sequential read 1 334728
> 01/25/2005 09:30:03 db file sequential read 1 289293
> 01/25/2005 09:45:25 db file sequential read 1 225040
> 01/25/2005 10:00:49 db file sequential read 1 212765
>
> SNAP_TIME PART NAME ELAPSED
> PERCENTAGE
> ---------------- ------------- ------------------------- --------
> ----------
> 01/25 21:00:25 Service Time Other cpu 1:04:28 70.44
> 01/25 21:00:25 Wait Time PL/SQL lock timer 0:14:47 16.16
> 01/25 21:00:25 Wait Time db file scattered read 0:06:17 6.86
> 01/25 21:00:25 Wait Time db file sequential read 0:02:22 2.59
> 01/25 21:00:25 Service Time parse time cpu 0:02:04 2.25
> 01/25 21:00:25 Service Time recursive cpu usage 0:01:08 1.24
> 01/25 21:00:25 Wait Time latch free 0:00:13 0.23
>
> 01/25 21:00:25 Wait Time log file parallel write 0:00:06 0.10
>
>
> btw, we run bmc patrol express, hence the pl/sql lock timer.
> We're getting an eval netapp filer, we'll see how that one performs...
> jan

Get a 920 and run it as both NAS and SAN.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)