What is SQL Profiler ?

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

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.


Login to post response