Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSAS 2005 Service dies - HELP!

Author  Topic 

richardps
Starting Member

33 Posts

Posted - 2007-04-11 : 05:39:29
When processing my very large cube, after 6 hours, the service dies and the ASCMD returns an error saying it can't find the server / service. The rest of the server is fine and I just have to restart the Service. But the ASCMD keeps killing the service. Can anyone offer some ideas of when I should be looking?

Windows Server 2003 SP1
4GB RAM
4 CPU

Many thanks in advance,
Richard.

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-17 : 09:43:13
Do you see any other error in error log and event viewer logs?
Also confirm the level of service pack on SQL ASAS, it could be a problem with dimensions and also you might run a trace at the same time to see the underline events.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net
Go to Top of Page
   

- Advertisement -