How to find out client process ID in SQL Server Profiler?

sql-server sql-server-profiler
Brijesh Patel picture Brijesh Patel · Jul 21, 2011 · Viewed 12.4k times · Source

I am using SQL Server Profiler to view my database activities. In that, I want to find out which Client Process ID is associate with which machine (From where application is running). because there are multiple instance of my application are running on different machines. So I want to identify them. So is there any way to find out ClientProcessID?

Answer

SQLMenace picture SQLMenace · Jul 21, 2011

you can use hostname in profiler, it is the same as the host_name() function in T-SQL

run this in a query window 

SELECT host_name()

In profiler it is hostname, you have to check "show all columns" to see it

Related questions

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.

Read More
Where is SQL Profiler in my SQL Server 2008?

I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere. I believe I installed the SQL Server Enterprise Express/trial version? I guess it was Express and not Enterprise after all right?

Read More
What does "exec sp_reset_connection" mean in Sql Server Profiler?

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed exec sp_reset_connection SQL:BatchStarting SELECT [c].[TestID] AS [TestID], [c].[…

Read More