Qus:    When you should use sql profiler and what is the purpose of sql profiler?
Dec 04, 2020 10:19 2 Answers Views: 84 PADMAKEECHU

 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.

Prev Next
Answers (2)
PARTH Dec 05, 2020 04:21
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.

SWEETY Dec 05, 2020 08:47
Answer:   It is used to capture the trace of the sql query log as background process in the table and database engine.

Post Your Answer
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect