Answer:   The purpose of SQL profiler is to monitor performance of various stored procedures and is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries.

You should use it to capture any problems by capturing the events on production environment so that they can be solved.

Answer:   It is used to capture the trace of the sql query log as background process in the table and database engine.