I have a cube with 6 dimensions and about 20 million records in fact table.
The same cube with the same schema, data, aggregation design etc. is being
processed 9 minutes on the old server (4xPIII, 2GB RAM) and 22 minutes on
the new one (4xPIVXeon, 8GB RAM, but with hyperthreading). What I have
noticed is that in the beginning reading speed is ok.but then it slows down
from row no. 15mln to 19 mln. Why it slows down in the middle of the cube...
Any ideas appreciated.

Thanx

Kuba

Hi,

Could you please check

whats the setting for Process Buffer size and Read-ahead
buffer size in both the machines.

Whether the /3GB switch is used in the boot.ini file and
also the Memory conservation threshold value in Analysis
Manager is set properly.

Also look at
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/maintain/Optimize/AnSvcsPG.asp

- Microsoft SQL Server 2000 Analysis Services Performance
Guide

Cheers,
Sanka

On the new machine all properties are set like described in MS Knowledge
base document 295443 entitled: INF: How To Enable Analysis Server to Use 3
GB of RAM. Old server uses less memory, as it has physically 2 GB. Analysis
Manager showes stupid negative values now, but proper values taken from
above mentioned document were taken.
One more detail is that the old machine did not use hyperthreading.

Regards

Kuba


Uzytkownik "Sanka" <loonysan (AT) mailcity (DOT) com> napisal w wiadomosci
news:e72201c3bc73$5a1bfb30$a601280a (AT) phx (DOT) gbl...

You didn't mention what version of Windows OS is on the new server. This
is important with hyper-threading, because W2K Server does not
distinguish between logical and physical processors. Thus, if you are
limited to 4 processors, 2 physical hyper-threading processors might get
disabled.

This Microsoft paper provides more details:

http://www.microsoft.com/windows2000...rthreading.doc
Windows 2000 Server does not distinguish between physical and logical
processors on systems enabled with Hyper-Threading Technology; Windows
2000 simply fills out the license limit using the first processors
counted by the BIOS. For example, when you launch Windows 2000 Server
(4-CPU limit) on a four-way system enabled with Hyper-Threading
Technology, Windows will use the first logical processor on each of the
four physical processors, as shown in Figure 2; the second logical
processor on each physical processor will be unused, because of the
4-CPU license limit. (This assumes the BIOS was written according to
Intel specifications. Windows uses the processor count and sequence
indicated by the BIOS.)
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I have Windows 2000 Advanced Server, so 8 CPUs should be supported and from
time to time it happens all of them are busy, but usually not during
processing.

Uzytkownik "Deepak Puri" <deepak_puri (AT) progressive (DOT) com> napisal w wiadomosci
news:OA7MJkVvDHA.3536 (AT) tk2msftngp13 (DOT) phx.gbl...