What is SQL Profiler what is the use of it?
Answers were Sorted based on User's Feedback
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 |
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 |
What is nolock hint in sql server 2008
What are different types of database indexes?
Distinguish between nested subquery and correlated subquery?
How to check parameter value in stored procedure sql server?
What is the importance of three tier architecture?
What is 3nf normalization?
What is sql server database?
What is the use of =,==,=== operators?
Where do we use trace frag?
What is primary key and example?
What is index in an assignment?
What is 3nf normalization form?