What is SQL Profiler what is the use of it?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an entity-relationship diagram (erd)?

588


How to make a column nullable?

602


What is the main difference between ‘between’ and ‘in’ condition operators?

588


What are some examples of schemas?

534


How to create hyperlink from returned sql query ?

625






What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

545


What are locks in sql?

541


What is partition index in sql server?

608


Tell me about joins in database system and explain each in detail.

598


How to find tables without indexes?

631


What stored by the tempdb ? : sql server database administration

569


explain different types of constraints? : Sql server database administration

518


What is log in sql server?

592


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

597


What is the purpose of the master database?

602