SQL Server Performance Forum – Threads Archive
Crashing of MSSQLServerOLAPServiceisHello My MSSQLServerOLAPServiceis (sp3) crashing and than restarted again, and so forth. I sucsessed to find one of my cube that make the above problem. I isolated the problematic cube and restarted the service and now it’s work fine. How things like that can happend ? Oryan
If its crashing you should check under error log for any information.
And also while applying SP3 check whether any issues were occured. _________
We’ve had cubes ‘corrupt’ on occassion, which has led to similar behaviour. Normally this occurs when the Repository hasn’t been migrated to MSSQL (highly recommended for PROD environments!). We’ve found the ‘multi-user’ side of MSAccess doesn’t always ensure non-corruption of the database. HTH, Steve.