Re: High IO Waiting...

shoad316_at_hotmail.com (Dave) wrote in message news:<78cf0572.0305051254.5738d9f8_at_posting.google.com>...
> Hey all,
>
>
> I have an application that extracts data from a schema, transforms
> it and places it into a datamart within the same database. I'm
> noticing a high amount of IO waiting varying between 20 and 75% during
> each run.
>
> From what I read, this doesn't necessarily mean there is a problem
> because the service times are low and there aren't any jobs waiting at
> the disk level. But a high IO wait like that tells me there is room
> for improvment.
>
> The system is setup as follows (don't blame me, I just got here. :)...
> I'm not sure of the systems exact stats but here's what I know
>
> Solaris 5.8 dual CPU
> 8 gigs of ram (~4gig still free)
> 18 gigs of swap (only 2 of which used)
> Database is stripped across 2 physical disks with a stripe size of 12
> gig. (I didn't know you could stripe as large as 12 gig!?)
> Mirrored to 2 other physical disks on the same controller..

in the world where licen$ing is an issue ... 2 CPUs of Standard Edition would list at $30,000 (per CPU licensing). 8 GB of memory for SPARC hardware? How much is that?

it seems as though the box is top heavy, and is not sitting on top of a worthy I/O subsystem.
Sounds like a $100,000 server (w/software) with $1000 worth of disks. maybe hawk half the ram on Ebay in exchange for a nice storage enclosure or at least several more drives.

in intel land, one can acquire a 14 drive external cabinet full of 36 GB hard drives for under $10,000. A pair of those could keep a CPU well fed - and give you lots of options for storage layouts.

Pd Received on Wed May 07 2003 - 00:12:30 CDT