You’re given a list of Windows servers and told they host multiple SQL Server instances. How do you find which services are running? Use Powershell:
get-service mssql* -computername myServer
It will give a nice list of services that have MSSQL at the beginning of their names:
| Status | Name | DisplayName |
| Running | MSSQL$INSTANCE2 | SQL Server(INSTANCE2) |
| Running | MSSQLSERVER | SQL Server(MSSQLSERVER) |
| Stopped | MSSQLServerADHe… SQL | Server Active Directory Helper |
| Stopped | MSSQLServerADHe… SQL | Active Directory Helper Service |
A shorter version:
gsv mssql* -cn myServer
