What is SQL Profiler what is the use of it?

Question Posted / srikanth

2 Answers
13451 Views
247Customer, Steria, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is SQL Profiler what is the use of it?..

Answer / tap_ks

SQl Profiler is a tool provided by SQL Server, which can
capture the queries, procedures executed on the database.
It also capture all the details like user, m/c, input
parameters, time of execution etc. This is very helpful
while bebugging any query / procedure.

Is This Answer Correct ?

21 Yes

2 No

What is SQL Profiler what is the use of it?..

Answer / rathi

SQL profiler is a graphical tool that allows system
administrator to monitor in an instance of the SQL Server.

Use of SQL Profiler:
• Monitor the performance of an instance of SQL
Server.
• Debug Transact-SQL statements and stored procedures.
• Identify slow-executing queries.
• Test SQL statements and stored procedures in the
development phase of a project by single-stepping through
statements to confirm that the code works as expected.
• Troubleshoot problems in SQL Server by capturing
events on a production system and replaying them on a test
system. This is useful for testing or debugging purposes
and allows users to continue using the production system
without interference.
• Audit and review activity that occurred on an
instance of SQL Server. This allows a security
administrator to review any of the auditing events
including the success and failure of a login attempt and
the success and failure of permissions in accessing
statements and objects.

Is This Answer Correct ?

13 Yes

2 No

Post New Answer