SQL Profiler

• vssohal

  SSC-Addicted

  Points: 411

  More actions

  March 29, 2004 at 11:24 pm

  #152094

   

  Can someone send me T-SQL examples to trace Long Running quries, queries generating Deadlocks and Stored Procedue tracking Using Profiler? Please also let me know which events,data columns and filters need to trace for all this.

   

  
  Vss

• MikeAtTheMill

  Old Hand

  Points: 398

  More actions

  March 31, 2004 at 2:58 pm

  #501378

  Hi vssohal -

  Yes.  I can plus I have a couple of great links to microsoft KBs.  But all my stuff is at work and I'm at home.  I will try to remember tommorrow morning.

  Regards,

  -Mike

  
  Mike at the Mill

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  March 31, 2004 at 3:01 pm

  #501380

  I've posted some links for you here:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=108917

  K. Brian Kelley
  @kbriankelley

• MikeAtTheMill

  Old Hand

  Points: 398

  More actions

  April 1, 2004 at 5:39 am

  #501417

  And here are a couple more:

  http://www.sqlservercentral.com/scripts/contributions/407.asp

  http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

   

  
  Mike at the Mill