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
exec xp_servicecontrol n'querystate',n'mssqlserverolapservice'
you can check status of service , take decision accordingly.
Comments
Post a Comment