RE: Slowness

Have you run UPDATE STATISTICS? If so, did you run update statistics high on your indexes ... If you have run UPDATE STATISTICS like the documentation suggests, other people have already asked for the info needed to help trouble shoot the slowness Hope this helps, Will >===== Original Message From Boscia <rwboscia@worldnet.att.net> ===== >First, I am a newbie, so I'm not real familiar with all this "stuff" yet... > >We recently moved our databases to another server. The new one is an Sun >E10K running Solaris 7. We have approximately 34 dbspaces and chunks. The >largest db contains approximately 150,000,000 records. My developer is >complaining about the slowness of the machine. He feels that it should be >MUCH faster than the old machine and he does not feel that it is. (It was >not an E10K). His db's are bigger on this machine. On the "old" machine, >the largest was 40,000,000 (it's the same database but now they are >retaining the data for a longer period of time.) The db's and chunks are >using 6 disks. > >Our server is showing that it is 82% idle most of the time. > >I think I read somewhere that the tempspace should have it's own disk (?). >We do not have it set up that way.... >What else can I look at to determine if this slowness issue is true and what >can I do about it? > >Thanks for your help.. > >Robin Boscia ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------