What is SQL Profiler what is the use of it?
Answer Posted / 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 View All Answers
What is normalization according to you and explain its different levels?
Explain various On-Delete options in a DB table. Which is the default option?
How do I view views in sql server?
Explain system scalar functions?
Explain what are various ways to enhance the ssrs report?
Explain few examples of RDBMS?
Explain data warehousing in sql server?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Explain the working of sql privileges?
What is the most common type of join?
What is difference between materialized view and view?
Can we use where and having clause together?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to perform key word search in tables?
How much space does sql server 2016 take?