Hi,
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.
Thanks in advance
Wes
> Hi,
> What is the SPID column for in SQL Profiler?
http://msdn2.microsoft.com/en-us/library/aa933157(SQL.80).as px
Regards,
Fritz
On Aug 20, 3:28 pm, wesleym...@gmail.com wrote:
> Hi,
> 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.
>
> Thanks in advance
> Wes
Hi Wes,
If for some reason the DatabaseName filter doesn't work, you can try
to filter by DatabaseID instead. To get the ID of your database, run
select db_id() against the database.
I also suggest you try out the tool SQL Trace Analyzer. It allows you
to filter your trace with very high granularity and provides detailed
information about your trace that's easy to understand. You can
download it from here: http://www.lakesidesql.com/tadownload/traceanalyzersignup/tr ace_analyzer_signup.aspx.
HTH
(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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx