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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | AgaKYak Posting Veteran
 
 
                                        86 Posts | 
                                            
                                            |  Posted - 2012-11-14 : 13:09:44 
 |  
                                            | We have a job to rebuild a SSAS cube every 30mins on SQL 2008 R2 10.50.2806 (on a vm). The job runs ok 99% of the time but once in a while it hangs and SSAS needs to be restarted. When the job hangs, Memory/ Cache Bytes, Processors/% Processor Time and Paging File/%Usage counters go up but the Memory/Available Mbytes stays stable. There are 32GB of RAM available.Any ideas why the job is hanging?Thank youAga |  |  
                                |  |  |  |