Interested to Buy Any Domain ? << Click Here >> for more details...
What is SQL Profiler what is the use of it?
- 2 Answers
- 13339 Views
- 247Customer, Steria, I also Faced
- E-Mail Answers
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
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What to check if a User database is locked?
What happens if null values are involved in bitwise operations?
What causes index fragmentation?
What is a livelock?
How to create a user name in a database?
What is the purpose of forms?
What is replication and database mirroring?
What options are available to audit login activity? : sql server security
What is side by side migration in sql server?
What are different types of collation sensitivity?
What does it mean to manipulate data?
What are the dis_advantages of stored procedures, triggers, indexes?
How do we synchronize On-Premise SQL server with SQL Azure?
How many types of local tables are there in sql server?
