SQL Script to check if cubes processes are running or not

Leave a comment (0) Go to comments

Following script will list down all processes which were being initiated by Analysis services

-- ***********************************************************************************/
-- Description  :    Script to check if cubes processes are running in the server
--                        Following script will list down all processes which were being initiated by Analysis services
-- Compatibility  :     7.0+
-- This Script should be executed in master
-- ***********************************************************************************/
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
EOF - SQL Script to check if cubes processes are running or not, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.