sql profiler custom filter

Friday, November 23, 2007 10:13 AM | Leave a reply »

the tip is simple u need to make a filter that filters and shows only your DB transactions on a server. what u need to do is to change your web.config by adding a string that you can later filter on

   1: <add key="Main.ConnectionString"
   2: value="data source=Server;initial catalog=dbName;
   3: User ID=sa;Password=userName;application name=thisIsTheFilter"
   4: />

 

 

now that you have something to distinct your connection from all other users all you have to do is open the profiler window and start a new trace ==> connect don't start the trace yet

click the image to enlarge

 

and that's all start ur trace



Comments

  1. Gravatar Anonymous says:

    Re : # 

    You've been kicked (a good thing) - Trackback from DotNetKicks.com


Leave a Reply



 

Please add 5 and 7 and type the answer here: