The indexes have been rebuilt a few times with little or no effect. In addition, due to the way that this DBMS works the indexes cannot be moved away from the data files. Good suggestions though, thanks!
----- Original Message ----- From: "CMB" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, December 02, 2003 10:08 PM Subject: Re: [brlug-general] Review of my performance analysis > I had an HP Box run IO numbers like that when its array ( a j-box) > was failing. > > I'm sure drive failure is not your problem.... > > From the looks of it, I'd look a little further away from the system... > maybe at...... DB Indexing. > > DB Indexing combined with a critical amount of data indexed can cause > the system to load down during read ops. I bet your db server does > not automatically clean indexes. See if you can rebuild the > indexes...or better yet, mount another drive and move the dbfiles and > indexes to that drive.
