Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

use of sp_showplan

2 posts in General Discussion Last posting was on 2013-03-05 18:18:57.0Z
newbiz Posted on 2013-02-28 06:05:53.0Z
Sender: 1b49.512ef082.1804289383@sybase.com
From: newbiz
Newsgroups: sybase.public.ase.general
Subject: use of sp_showplan
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <512ef3c1.1d28.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 27 Feb 2013 22:05:53 -0800
X-Trace: forums-1-dub 1362031553 172.20.134.41 (27 Feb 2013 22:05:53 -0800)
X-Original-Trace: 27 Feb 2013 22:05:53 -0800, 172.20.134.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31715
Article PK: 1307989

Hi,

Can sp_showplan be used to read processes? To read exactly
the sql statement executed in the process? Thank you very
much


Harry Splinter Posted on 2013-03-05 18:18:57.0Z
Sender: 2db4.51363562.1804289383@sybase.com
From: Harry Splinter
Newsgroups: sybase.public.ase.general
Subject: Re: use of sp_showplan
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <51363711.2e4a.1681692777@sybase.com>
References: <512ef3c1.1d28.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2013 10:18:57 -0800
X-Trace: forums-1-dub 1362507537 172.20.134.41 (5 Mar 2013 10:18:57 -0800)
X-Original-Trace: 5 Mar 2013 10:18:57 -0800, 172.20.134.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31721
Article PK: 1308117


> Hi,
>
> Can sp_showplan be used to read processes? To read exactly
> the sql statement executed in the process? Thank you very
> much.

Hi sp_showplan only shows the currently executing SQL
statement.
If you want to see the statements executed in the process
you could use mda/monitoring tables (explaned
here:http://www.sypron.nl/mda.html)