SQL Server Performance Forum – Threads Archive
Crashing of MSSQLServerOLAPServiceis
Hello 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 ? OryanIf its crashing you should check under error log for any information.
And also while applying SP3 check whether any issues were occured. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
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.
]]>