performance hit after installing Oracle client?

SQL Server 2000 Enterprise Edition clustered on Win 2k Advanced Server
Last week we installed the Oracle client 8.1.6 to allow DTS to extract data
from our Oracle Financials system, which has been working fine. Since then u
sers have reported poor performance. Performance monitor showed low (20-30%)
CPU usage, 99.9% buffer ca
che hit ratio, usual disk utilisation amounts, but Pages/sec was averaging a
round 300. I understand this should be under 20. There is nothing else runni
ng on this server. We took the server down and switched to another node whic
h did not have the Oracle c
lient loaded and performance is back to usual. Has anyone else had a similar
problem, or is the Oracle software just a red herring?
Scott Doughtykevmc@.online.microsoft.com (Kevin McDonnell [MSFT]) wrote in message news:<ByFbcLS4DHA.568@.cpmsftngxa07.
phx.gbl>...

quote:

---

> When the performance was poor did you have multiple instances of SQL
> running on the same node?
> Did the performance improve after moving a single instance of SQL to
> another node?
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.

---

Hi Kevin
We only had one instance running. We switched to another node which
didn't have the Oracle client installed and all was fine. As I say,
the oracle software may not be relevant. If it helps, while the paging
was running high, the amount of free RAM was over 200Mb.
Scottsql

Percentage measure

Hi,

easy question for advanced users:

I have a dimension called "Movement rate". The members are "1" to "6".
There is a measure called "No. of Products".

What i easily like to do is showing the percentages "No. of Product" for each "Movement rate" of the amount of "No. of Products" without using the frontend-tool.

Thx in advance for any help.

AndreasWhat is your table layout?|||Just for ur further explanation:

I like to get the following (red) result:

Movement rate No. of Products No. of Products in %
1 100 10
2 100 10
3 200 20
4 300 30
5 200 20
6 100 10
Amount: 1000 100

My table design is the following:

"Movement rate" int
"No of Products" int

I don't know for what reason u need this table design, cause what I need is the MDX - Query for my cube.

Thx.