top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What is SQL Profiler?

+4 votes
What is SQL Profiler?
posted Feb 20, 2014 by Khusboo

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
Best answer

SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file. You can then analyze or use the trace file to troubleshoot logic or performance problems.

You can use this utility to monitor several areas of server activity, such as:
Analyzing and debugging SQL statements and stored procedures.
Monitoring slow performance.
Stress analysis.
General debugging and troubleshooting.
Fine-tuning indexes.
Auditing and reviewing security activity.

To access Profiler, you must be the administrator or have permission to connect to a specific instance of SQL Server and have granted permissions to execute Profiler stored procedures.

answer Feb 20, 2014 by Amit Kumar Pandey
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.