Roman's Weekly SQL Server Tip - How to map SQL Server to the process ID
If you have multiple instances of SQL Server running on the same computer, you might run into run into a situation where you need to identify what server instance corresponds to the SQL Server executable. Windows Task Manager shows you the process ID (PID) of each instance of sqlserver.exe. You can find out the process ID of each running SQL Server by executing this code:
SELECT SERVERPROPERTY('ProcessID')