Slowness
Posted in 2000
Topics: Storage & Space Management, Platform-Specific Issues
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
Can you provide us with:
Version of IDS used
Your ONCONFIG file
Tell us how you migrated to the new machine
Some output from onstat -p
These will help a sensible diagnosis
Boscia wrote in message ...
>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
>