How Can You find out Process ID for SQL Server Services?


After the execution of above script you will get information like service status, process Id, last startup time and service account.



SELECT ServiceName, status_desc,
process_id, last_startup_time, service_account
FROM sys.dm_server_services

After the Execution of Above Script you will get the output in below format:-


 

Leave a Reply

Your email address will not be published. Required fields are marked *