Comments on: SQL Server Services https://virtual-dba.com/blog/sql-server-services/ Remote Database Administration Thu, 06 Jul 2023 15:40:32 +0000 hourly 1 https://wordpress.org/?v=6.9.4 By: jim ziegmann https://virtual-dba.com/blog/sql-server-services/#comment-3486 Thu, 06 Jul 2023 15:40:32 +0000 https://virtual-dba.com/?p=34837#comment-3486 Try this using SSMS it allows you to see status of SQL Server and SQL Agent Service for one or all of your SQL servers quickly.

SELECT [servicename], [status_desc], [startup_type]
FROM sys.dm_server_services
WHERE [servicename] LIKE N’SQL Server Agent (%’ OR [servicename] LIKE N’SQL Server (%’

]]>