How to determine which SSAS Cube is processing now?

sql-server-2008-r2 ssas olap
Alekzander picture Alekzander · Aug 10, 2012 · Viewed 26.2k times · Source

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.

Answer

Diego picture Diego · Aug 10, 2012

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

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

Related questions

OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE

I use SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio. I create one project of Business Intelligence Project I create a Data Source Of Adventure Work 2008 DW and then i create one Data Source View and then i …

Read More
DateAdd Column caused an overflow

After executing the following query I am getting an error Adding a value to a 'datetime' column caused an overflow. I have no idea why this is happening as it worked smoothly for a couple of weeks. I am just …

Read More
Why to build a SSAS Cube?

I was just searching for the best explanations and reasons to build a OLAP Cube from Relational Data. Is that all about performance and query optimization? It will be great if you can give links or point out best explanations …

Read More