Post reply

Is there an sp_showplan command?

  • 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

  • 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.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply