We have moved an analysis server database from single processor desktop machine to a dual processor server with 1GB RAM and hyperthreading. The desktop machine processes the cubes faster. Everthing is identical except for the fact that the server has SQL Server Enterprise version while deskstop is standard. The other difference is that the server is configured for http access to Analysis server. All the standard performance counters(disk,memory,processor) do not indicate problems. Any ideas? spz
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9599 Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.