Wednesday, January 5, 2011

How to use SQL Server profiler for basic profiling?

PROBLEM:
How to use SQL Server profiler for basic profiling?

SOLUTION:
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.
Open SQL Server profiler. If the following window not open, choose the "New Trace" button.
Use the "Standard (default)" template and go to the "Event Selection" Tab

In the event selection tab choose only

  • "RPC:Completed"
  • "SQL:BatchCompleted"

Press the run button


Now you can start to traces and analyze your queries or applications..
For more information, visit here

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

No comments:

Post a Comment