SQL Profiler

SQL Profiler

is a tool,which is used to capture events from a server.These events are saved in a trace file that is referred to later to replay a specific series of steps when trying to diagnose a problem.SQL Profiler is used for the following activities.

1> Stepping through problem queries to find the cause of the problem.

2>Finding and diagnosing slow-running queries.

3>Capture the series of SQL statements that lead to a problem.The saves trace can
then be used to replicate the problem on a test server where the problem can be diagnosed.

4>Monitoring the performance of SQL Server to tune workloads.

SQL Profiler can be accesed from the Tools menu of SQL Enterprise Manager.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: