如何确定现在正在处理哪个 SSAS Cube? [英] How to determine which SSAS Cube is processing now?
本文介绍了如何确定现在正在处理哪个 SSAS Cube?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当多个用户可以同时处理同一个多维数据集并导致多维数据集处理失败时会出现问题.所以我需要检查当前是否正在处理某个多维数据集.
There is a problem when several users can process the same cube simultaniously and as a result processing of cube fails. So I need to check if certain cube is processing at current moment.
推荐答案
如果其他人已经在处理一个多维数据集,我认为你不能阻止它被处理.您可以对帮助"执行的操作是运行 MDX 查询以检查上次处理多维数据集的时间:
I dont think you can prevent a cube from being processed if someone else is already processing it. What you can do to "help" is run a MDX query to check the last time the cube was processed:
SELECT CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBES
或者检查realted sql server实例上的sys.process表看它是否正在运行:
or check the sys.process table on the realted sql server instance to see if it is running:
select spid, ecid, blocked, cmd, loginame, db_name(dbid) Db, nt_username, net_library, hostname, physical_io,
login_time, last_batch, cpu, status, open_tran, program_name
from master.dbo.sysprocesses
where spid > 50
and loginame <> 'sa'
and program_name like '%Analysis%'
order by physical_io desc
go
这篇关于如何确定现在正在处理哪个 SSAS Cube?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文