Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1570
  • Last Modified:

SPID and ClientProcessID

What's the difference for SPID and ClientProcessID in SQL 2008 Profiler ? After I stop the process, can I filter the result by SPID ?

Tks
0
AXISHK
Asked:
AXISHK
1 Solution
 
Eugene ZCommented:
yes, you can sort by SPID



ClientProcessID:
 ID assigned by the host computer to the process where the client application is running. This data column is populated if the client process ID is provided by the client.  


SPID:
Server Process ID assigned by SQL Server to the process associated with the client.

more:
SQL Profiler Data Columns
http://technet.microsoft.com/en-us/library/aa173882(v=sql.80).aspx
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now