SQL Server Performance

Crashing of MSSQLServerOLAPServiceis

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

  1. oryand New Member

    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 ?

    Oryan
    oryand, Dec 2, 2003
    #2

  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
    Moderator
    SQL-Server-Performance.Com
    satya, Dec 2, 2003
    #2

  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.

    HTH,

    Steve.
    stevefromOZ, Dec 2, 2003
    #2

Share This Page