Which PDI (Process ID) is SQL Server running.

There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in task manager) is mapped to which specific instance of SQL Server running on a server, if you have a multi-instance server and the account running each separate SQL Service is the same. I won’t go into the details of the post, but I thought the answer worth of a post of my own. As with most things in SQL Server there is more than one way to obtain this information.

Hands-on:

• Open up SQL Configuration Manager
• On the SQL Services tab right click on the SQL instance that you want to match up to a process
• Select <Properties> and click the <Services> tab
• On the general tab you should see a process id property.