
Question:
Is there a quickstart guide on how to configure SQL profiler for SQL 2005? I am using a shared database, so I want to only view queries that are executed by my application.
Solution:1
On the Trace Properties, 'Events Selection
' tab, there is a Button named 'Column Filters..
' Click on this button launches a dialog where allows you to filter your profiling.
One of the filters is called ApplicationName
. Click on 'ApplicationName
' item on the left and you get right hand side pane with Treeview Node
where you can type in the name of your application in the 'Like
' Node
Just found this documentation on MSDN
Solution:2
You can filter by things like ApplicationName or LoginName
Trace Properties Events Selection tab Column Filters Button.
Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
EmoticonEmoticon