Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Posts
    207

    Unanswered: Coming from Sybase

    Coming from Sybase env. I would like to know the equivalent of sp_showplan. What it does is, it shows the showplan for the query being run by spid, which is passed as a parameter to sp_showplan.

    Thanks for your help.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I think that SET SHOWPLAN_TEXT is about a close as you are going to get. The SQL Profiler allows you to get plan information as the SQL is submitted to the server, but I don't know of any way to retroactively see the plan generated by another spid even if you are a member of the sysadmin group (Microsoft's equivalent to Sybase's sa).

    -PatP

  3. #3
    Join Date
    Nov 2002
    Posts
    207
    In that case, how would you check the performance issue with a third party front end application running on MS SQL Server. Only thing you know is SPID with which the application is running - either a report or a batch job. I tried SQL profiler, but couldn't get anything in the output. I might be missing something.

    Appreciate all your help.

    Thanks.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    When you set up the trace file, under the Performance class add one of the Show Plan events. Tracing those events will show you many times more than what sp_showplan could.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •