Using SQL profiler stored procedures

• vijaygill

  SSC-Addicted

  Points: 464

  More actions

  June 7, 2002 at 5:14 am

  #158343

  Hi,

  Can anybody tell how to use the profiling stored procedures in SQL 2000. Basically I want to write my own Profiling utility to monitor the database activity and plot graphs of the various operations carried out.

  I will be using Delphi 6 for that purpose.

  Thanks in advance.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 7, 2002 at 6:23 am

  #430504

  BOL is not bad, but by far the easiest way is to set up trace in Profiler and then save it out as a script file. That will give you almost everything you need.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter