What is SQL Profiler ?

 Posted by Bharathi Cherukuri on 3/17/2012 | Category: Sql Server Interview questions | Views: 5824 | Points: 40
Answer:

SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server.
You can capture and save data about each event to a file or SQL Server table to analyze later.
You can use SQL Profiler to monitor only the events in which you are interested.
For example, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Bharathi Cherukuri on: 4/30/2012 | Points: 10
Hi Pervej,

You have posted a wrong link..Please provide the correct one.

Thanks,
Bharathi

Login to post response