|
| Dear Sirs,
We have a 3 tier app that runs on w2003 and uses COM, it queries OLTP
(10%) and OLAP (90%) Databases directly from ASP.
We used to run on 2 boxes of 2 HT processors (3.06 GHZ), running in the
first box only OLAP and in the other IIS, COM and OLTP.
We migrated to an AMD Opteron with 4 Dual Core Processors (8
processors) and 6 GB of RAM. But the overall performance of the system
has lowered its performance.
The bottleneck of this system is not SQL SERVER (OLTP) but OLAP. As
soon as we get aprox. more than 80 or 90 connections in Analysis
Services, the performance indicator Avg Time / query starts go up.
>From the client perspective when there are peaks the page shows the
message "provider error", because OLAP cant handdle more requests
apparently.
The only indicator that the system is running slow is the Avg Time /
query indicator.
If you monitor Analysis Services performance indicators, everything is
running smooth, no indicator passes its threshold, al threads are being
responded, all pools are ok, there are no queues.
But the system has a lot of processors to use, and connection errors
with analysis services ocurr with processors at 30%.
Our first assumption is that Analysis Services 2000 does not work
appropriately with dual core processors. Does not take advantage of the
power of this processors, because before it worked well with Processors
with HyperThreading Technology.
I have seen posts that talk about the same issue but with SQL
SERVER(OLTP) not with OLAP.
I will appreciate all help related to this subject.
Regards,
Benja
|
|