Profiler in SQL

SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

You need to check this to know fully about profiler.

http://msdn.microsoft.com/en-us/library/ms181091.aspx

and u need to check this to know how to use profiler.

http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step

Hi Sharad,

Please refer the below links

http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step

http://msdn.microsoft.com/en-us/library/ms181091.aspx

http://msdn.microsoft.com/en-us/library/aa173918%28v=sql.80%29.aspx

http://www.techrepublic.com/article/step-by-step-an-introduction-to-sql-server-profiler/5054787

Thanks