自动监控分析服务可用性 [英] Automatically monitoring analysis services availability

问题描述

由于分析服务停止运行，我们在几天内面临一个问题，这会影响我们自动化的Job失败。

是否有自动检查分析服务是否正在运行的方法，如果它已停止，则再次启动它。

提前致谢。

Pankaj

解决方案

您可以在SQL上找一份工作Servwer数据库服务器，在该作业中，如果您能够连接到该服务，则可以命令查询您的SSAS服务。那个SSAS实例然后你看到它在线或离线，你需要排除故障。

链接是：

https://docs.microsoft.com/en- us / sql / analysis-services / instances / monitor-an-analysis-services-instance？view = sql-server-2017

https:// docs.microsoft.com/en-us/sql/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/analysis-services/instances/monitor-analysis-services-with-sql-server-extended-events?vi ew = sql-server-2017

第三方工具太多，无法检查状态并提醒您。例如Sentry..Idear，SQLShack等..

Hi,

We are facing one issue from few days as the analysis service is stopped running, this impacts on our automated Job it get failed.

Is there a automated way to check if the analysis service is running and in case if it is stopped then start it again.

Thanks in advance.

Pankaj

解决方案

You can put a job on SQL Servwer database server and in that job, put a command to query your SSAS services if you are able to connect to  that SSAS instance then you see its online or its offline and you need to troubleshoot.

Links are:

https://docs.microsoft.com/en-us/sql/analysis-services/instances/monitor-an-analysis-services-instance?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/analysis-services/instances/monitor-analysis-services-with-sql-server-extended-events?view=sql-server-2017

There are too many third party tools too to check status of it and alerts you. For example Sentry..Idear, SQLShack etc..

这篇关于自动监控分析服务可用性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！