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
↪ replying to 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
>