Profiler in SQL

Question

What is Profiler in SQL.

Santhosh Kumar Jayaraman · Answer

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

Satyapriya Nayak · Answer

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