Interview Question
Qus: When you should use sql profiler and what is the purpose of sql profiler?
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.
Answers (2)
You should use it to capture any problems by capturing the events on production environment so that they can be solved.