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

Load Balancing in Bluemix using custom domain and DNS SRV records -

oracle - pls-00402 alias required in select list of cursor to avoid duplicate column names -

python - Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>] error -