server - How to check if SSAS service is responding -


is there way check if analysis service installed on server not responding , requires restart ? been looking @ ssas dmvs :

  • select * $system.discover_connectionsgo
  • select * $system.discover_object_memory_usage
  • select * $system.discover_locks

but dont feel answer question.

thanks in advance.

try this: here mssqlserverolapservice name of sql analysis service , can found here

exec xp_servicecontrol n'querystate',n'mssqlserverolapservice' 

you can check status of service , take decision accordingly.


Comments

Popular posts from this blog

javascript - How to get current YouTube IDs via iMacros? -

c# - Maintaining a program folder in program files out of date? -

emulation - Android map show my location didn't work -