Wednesday, December 1, 2010

How to filter SQL Server Profiler Log

SQL Server Profiler shows how SQL Server resolves queries internally. on Microsoft SQL Server Management Studio on Menus Tools-> SQL Server Profiler.



as you can see the log file generated is too big to track. by adding Application Name to ConnectionString , you can filter the Log file:



server=MyServer;database=MyDatabase;Integrated Security=SSPI;Application Name=My Application;

No comments:

Post a Comment