none
SQL Server Analysis Services RRS feed

  • Question

  • Hi Everyone,

    Can we write script to generate alert on the SQL Analysis Service database goes to suspect mode.
    Or query that check all the SSAS database status even from the link-server between SQL and Analysis service.

    Thanks for your time
    Thursday, December 5, 2019 11:58 AM

All replies

  • You could just create a SQL Agent job which checks integrity of SSAS database daily & configure notification to alert you when integrity check fails.

    Database Consistency Checker (DBCC) for Analysis Services

    HTH,


    Phil Streiff, MCDBA, MCITP, MCSA

    Thursday, December 5, 2019 2:59 PM
  • Hi Phil,
    Thanks for response 
    We have alot of Database with complex data model in AS.
    We want to run this process of checking the suspect mode in every half hour. AS DBCC is an expensive process.
    Is it better we can just write a small procedure that just run small query on AS data base through link-serverrather rather than DBCC.
    What is your opinion on this.
    I have this procedure and run it just take 2 to 3 min to finish.

    Regards,
    Friday, December 6, 2019 4:59 PM
  • Hi Kazimcc01,

    Thanks for your reply.

    >>We want to run this process of checking the suspect mode in every half hour. AS DBCC is an >>expensive process.

    Why do you need to execute it every half an hour? In my opinion, there is no need to do it like that. Are your models always corrupted?

    As you know, the DBCC command require SSAS administrator to run it, other ordinary accounts couldn't do that. Therefore, it belongs to admin category.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, December 9, 2019 6:06 AM