← script library

Streamline SQL Server Service Checks with PowerShell

Software DeploymentDecember 24, 2024

In this post, we will present a PowerShell script designed to check the status of SQL Server services on your machine or across your network. Ensuring that your SQL Server services are running smoothly is vital for maintaining database availability and performance. This script allows administrators to quickly verify the status of each SQL Server service, making it easier to troubleshoot potential issues. Here is the PowerShell script for checking SQL Server service status:

powershell
# Define the SQL Server services to check
$services = @("MSSQLSERVER", "SQLAgent$SQLEXPRESS")  # Add your SQL Server instance names as needed
# Check the status of each service
foreach ($service in $services) {
    $serviceStatus = Get-Service -Name $service -ErrorAction SilentlyContinue
    if ($serviceStatus) {
        Write-Host "$($serviceStatus.DisplayName) is currently $($serviceStatus.Status)." -ForegroundColor Green
    } else {
        Write-Host "Service $service is not found." -ForegroundColor Red
    }
}

Run it across your fleet

This script runs as-is on a single host. Paste it into ServerEngine to schedule it, run it on a whole server group in parallel, and keep the credentials out of the file — see the scripts documentation and the credential store.

Ready when you are.

Try ServerEngine free for 7 days.