Re: Slowness again

From: Boscia <rwboscia@worldnet.att.net> > >OK so I changed the LRUS to 127 and the CLEANERS to 80 but did not yet >change the LRU MAX and MIN. Had a few different suggestions on ratio, but >what number do I start at for the MAX? Right now it is 60. Is there some >kind of calculation that I would use? How about 4/2? >(Now I didn't say this for sympathy, Just as well... >I am leery of making all the changes that were suggested at once, so which >ones are the most important? Or are they all equally important? Yes. >One suggestion was also to look at the disks (rearrangement). When we look >at the machine, our i/o's are at 1%, so would there be a need to rearrange >the data on the disks? My System Admin feels that would not solve >anything. Fair enough. But IIRC you have some "hot" disks and some idle ones. It might therefore be better to spread the load. Have you run UPDATE STATISTICS? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com