What is SQL Profiler?

What is SQL Profiler?

SQL Profiler is basically a graphical tool, Which is mainly use for allow to system administrators to monitor events in an instance of Microsoft SQL Server. We can capture and save data about each event to a file or SQL Server table to analyze later. For example, we can monitor a production environment to see which stored procedures are hampering performances by executing too slowly. Its mainly Use SQL Profiler to monitor only the events in which we are interested. We can filter the events based on the information we want, when It traces are becoming too large, That\'s why only a subset of the event data is collected.In server many overhead events are added from the Monitor and the monitoring process and because the trace file or trace table to grow very large, Specially when the monitoring process takes place over a long period of time.

Date:2010-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher