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

sql-server profiler sql-server-profiler
G - M picture G - M · Nov 7, 2008 · Viewed 220.4k times · Source

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.

Answer

Gulzar Nazim picture Gulzar Nazim · Nov 7, 2008

Under Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the database name. Enter the database name for the Like section and you should see traces only for that database.

Related questions

Oracle: is there a tool to trace queries, like Profiler for sql server?

i work with sql server, but i must migrate to an application with Oracle DB. for trace my application queries, in Sql Server i use wonderful Profiler tool. is there something of equivalent for Oracle?

Read More
How to profile for one table in SQL Server?

How can I add a filter which can trace sql statements for a particular table name?

Read More
SQL Server Profiler : How to specify multiple values for "NOT LIKE" column filter

According to : http://msdn.microsoft.com/en-us/library/ms175061.aspx It says that the "NOT LIKE" relational operator : "Specifies that the trace event data must not be like the text entered. Allows multiple values." But HOW do you specify multiple …

Read More