Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How to check SSAS service status with Powershell

14 June,2021 by Tom Collins

Question: How can I check for the SQL Server Analysis  Service service status with Powershell?    The status checks should be for remote servers

Answer: As long as you have network access & permissions, you can run similar to the below command. This example targets 1 server , but you could easily iterate through a list of servers. 


Get-Service *OLAP* -ComputerName MYSERVER | select MachineName, Status, Name, DisplayName


MachineName Status Name DisplayName
----------- ------ ---- -----------
MYSERVER Running SQLServerAnalysisServices SQL Server Analysis Services


Read more on running commands across multiple servers

How to get FQDN of multiple servers with Powershell 



Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to check SSAS service status with Powershell | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer