Interested to Buy Any Domain ? << Click Here >> for more details...
What is SQL Profiler what is the use of it?
- 2 Answers
- 13325 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
what is difference between NULL and ISNULL in SQL Server 2008?
What are the advantages of log shipping?
What is inner join? Explain with an example?
What is stretch database in sql server?
Explain activity monitors
What is report rendering ?
what do you understand by change data capture?
Suggest a method of joining two tables.
What is single-user mode?
Are null values the same as that of zero or a blank space?
What is the difference between commit and rollback?
Does a server store data?
How to turn off warning messages during php execution?
What is sql view?
What are the 10 characteristics of data quality?
