SSAS中的错误日志记录 [英] Error Log records in SSAS

问题描述

我们正在工作活动监视器中每天处理多维数据集，但在周末，w正在接收电子邮件通知，如cube processing hase was failed。有什么办法在多维数据集上维护错误日志（如ssis）？

We are processing cubes every day in job activity monitor, But on weekends w are receving email notification like "cube processing hase been failed". Is there any way to maintain error logs (like in ssis) on cubes?

推荐答案

维护Analysis的错误日志的关键机制服务是：

The key mechanisms for maintaining error logs for Analysis Services are to either:

1. 跟踪存储在 msmdsrv.log 中的数据。如果您使用Analysis Services 2005,2008或2008 R2，则可以生成自己的跟踪事件，如分析服务处理最佳实践的系统范围跟踪文件部分： http://technet.microsoft.com/en-us/library/cc966525.aspx#EBAA


2. 如果您使用SQL Server 2012，可以使用 XEvents 功能，如SSAS文档中所述使用SQL Server扩展事件（XEvents）来监视Analysis Services，网址为： http://msdn.microsoft.com/en-us/library/gg492139.aspx

1. Keep track of the data stored in the msmdsrv.log. It will be necessary to copy the log off before it gets overwritten.
2. If you are using Analysis Services 2005, 2008, or 2008 R2, you can generate your own trace events as noted in the System-wide Trace file section of the post Analysis Services Processing Best Practces at: http://technet.microsoft.com/en-us/library/cc966525.aspx#EBAA
3. If you are using SQL Server 2012, you can use the XEvents feature as noted in the SSAS documentation Use SQL Server Extended Events (XEvents) to Monitor Analysis Services at: http://msdn.microsoft.com/en-us/library/gg492139.aspx

另一种方法是使用SQL Server Profiler在后台运行，以便您可以记录所有事件。但这将类似于＃2选项。

Another approach is to use the SQL Server Profiler runnning in the background so that way you can record all events. But this would be similar to the #2 option.

另请注意，＃3选项（使用XEvents）在资源利用率方面对Analysis Services服务器的影响最小。

Also note that the #3 option (using XEvents) has the least impact on your Analysis Services server in terms of resource utilization.

这篇关于SSAS中的错误日志记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！