SQL Server Performance

Crashing of MSSQLServerOLAPServiceis

Discussion in 'Analysis Services/Data Warehousing' started by oryand, Dec 2, 2003.

  1. oryand New Member


    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 ?

  2. satya Moderator

    If its crashing you should check under error log for any information.
    And also while applying SP3 check whether any issues were occured.

    Satya SKJ
  3. stevefromOZ New Member

    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.



Share This Page