Solved

SPID and ClientProcessID

Posted on 2014-01-09
1
817 Views
Last Modified: 2014-01-10
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
Comment
Question by:AXISHK
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 39770735
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now