Posted by Erland Sommarskog on 08/20/07 21:56

(wesleym312@gmail.com) writes:
> What is the SPID column for in SQL Profiler?
> I have many databases but I only want to view the transactions on one
> particular database. What changes should I make to the filters inorder
> to achieve this. I have tried database name but that doesnt work.

SPID is the session id, and this is column is very good when you want to
watch a single process.

If you you want to view events from many sessions for one database, use
database id, this column is more often populated.

Note however that by default, you also get events where the filtered
column is not populated. On SQL 2000 this is difficult to avoid. On
SQL 2005 there is a checkbox for this.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]