iisweb-applicationswindows-server-2012-r2diagnostics

How can I correlate a running instance of W3wp.exe to a particular web application?

SQL Server Profiler is showing me the process Id for a particular database accessor.

Windows Task manager shows me that that process Id belongs to W3wp.exe.

How can I tie this back to the web application? (I have multiple web applications running on this server.)

Solution

  • You could use the iis manager worker process feature to check which process belongs to which application.it shows you all running worker processes and some basic info, including ProcessId.You can match that ProcessId to the Processes tab in Task Manager.

    Option A - GUI

    1. Open iis manager, select the server node.

    2. Double click on the worker processes feature.

      enter image description here

      enter image description here

    Option B - CLI

    1. Another thing you could try is run below command.

      %windir%/system32/inetsrv/appcmd list wp

    2. it will show the process with the application pool name:

      enter image description here