Is there an sp_showplan command?

• dj_meier

  SSCrazy

  Points: 2732

  More actions

  October 31, 2002 at 7:02 am

  #58602

  Sybase has a system command called sp_showplan that will show the execution plan for a running spid. Is there a way to do this in SQL Server? I know that you can run a DBCC INPUTBUFFER(spid) command to see what command was last sent to the server.

  Thanks.

  
  -Dan

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  October 31, 2002 at 2:54 pm

  #439993

  I Think there is not. With profiler you could check the queries and filter some users. But it's not the same.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 1, 2002 at 5:20 am

  #440037

  Or you can setup traces on the server to ouptu to a Profiler file. Nothing to show live except Profiler itself.