:::: MENU ::::

Friday, June 7, 2019

This is a simple PowerShell function that gets all services related to SQL Server services on a computer with its status (running or stopped).

1
2
3
4
5
6
function Get-SQLServices
{
Get-Service | Select-Object Name, Status, DisplayName | 
Where-Object Name -like *sql* | Sort-Object Status -Descending | 
Format-Table -AutoSize
}

Name Status DisplayName ---- ------ ----------- MSSQLServerOLAPService Running SQL Server Analysis Services (MSSQLSERVER) SQLWriter Running SQL Server VSS Writer SQLTELEMETRY Running SQL Server CEIP service (MSSQLSERVER) MSSQLFDLauncher Running SQL Full-text Filter Daemon Launcher (MSSQLSERVER) MSSQLSERVER Running SQL Server (MSSQLSERVER) SQLPBENGINE Stopped SQL Server PolyBase Engine (MSSQLSERVER) SQLSERVERAGENT Stopped SQL Server Agent (MSSQLSERVER) SQL Server Distributed Replay Controller Stopped SQL Server Distributed Replay Controller MSSQLLaunchpad Stopped SQL Server Launchpad (MSSQLSERVER) SQL Server Distributed Replay Client Stopped SQL Server Distributed Replay Client SQLPBDMS Stopped SQL Server PolyBase Data Movement (MSSQLSERVER) SQLBrowser Stopped SQL Server Browser

2 comments:

  1. I found decent information in your article. I am impressed with how nicely you described this subject, It is a gainful article for us. Thanks for share it. essay custom writing service online

    ReplyDelete
  2. Thank you so much for exploring the best and right information.

    SQL Server Load Soap API

    ReplyDelete