Why Use SQL Profiler in Microsoft SQL server

Uses of SQL Profiler in Microsoft SQL server

SQL Profiler captures SQL Server events from a server. These events are saved in a trace file that can be used to analyze and diagnose problem.

There are many other useful function of SQL Profiler, these are following :

• SQL Profiler used to find the cause of the problem by stepping through problem queries.
• SQL Profiler is very useful to analyze the cause of slow running queries.
• SQL Profiler can be used to tune workload of the Microsoft SQL server.
• SQL Profiler also stores security-related actions that can be reviewed by a security administrator.
• SQL Profiler also supports auditing the actions performed on instances of Microsoft SQL Server.

See Also