Find SQL query text on Sybase 11 ? 
Author Message
 Find SQL query text on Sybase 11 ?



Quote:
> We would like to know if we can find the text of the query SQL running on
> the system without buying specific monitoring products (i.e. using query on
> system table, keeping data from memory, .... ????).

Not with System 11.0.x - this is possible with 11.5 (now called Adaptive
Server Enterprise - Oh the joys of marketing!).

In 11.5 you use the sp_showplan <spid> stored procedure as an SA to see the
plan.  To see the stored procedure text you'll need Server Monitor.

Eoin.
--
Eoin Woods, Watford, Hertfordshire, WD1 1PD, UK



Sun, 09 Apr 2000 03:00:00 GMT
 Find SQL query text on Sybase 11 ?

: We would like to know if we can find the text of the query SQL running on
: the system without buying specific monitoring products (i.e. using query on
: system table, keeping data from memory, .... ????).

Haved you checked out Sybase auditing?  The capability comes with your
server; you just have to install the sybsecurity database (from sybinit).
You'll find a write-up on auditing in the Security Admin. Manual in
the System 11 documentation.  I think it was in the System Admin. Manual
in the System 10 documentation.  

Capturing SQL statements is done by auditing individual logins (e.g.,
sp_auditlogin username, "cmdtext", on ).  This captures all SQL statements
for a particular user into the sysaudits table in sybsecurity.  You can
then query that table and generate whatever reports you want/need.
Note, you would have to "cmdtext" captures SQL statements only -- not
stored procedure calls.  You would audit stored procs separately.

                                Hope this helps
                                Teresa Larson

     _________________________________________________________________
    /  Teresa A. Larson                 http://www2.ari.net/jmasino/ /
   /  Bell Atlantic                          Voice: (301) 282-0224  /
  /  13100 Columbia Pike, A-3-3              Fax:   (301) 282-9416 /

/________________________________________________________________/
                      #include <std_disclaimer>



Sun, 09 Apr 2000 03:00:00 GMT
 Find SQL query text on Sybase 11 ?

We would like to know if we can find the text of the query SQL running on
the system without buying specific monitoring products (i.e. using query on
system table, keeping data from memory, .... ????).

Thanks in advanced.

Taddei Cristiano



Sun, 09 Apr 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. migrate Sybase 11.0.1 and Sybase 11.5.1 to MS sql 6.5/7.0

2. Upgrade from Sybase SQL Server 11.0.1 to Sybase ASE 11.9.2

3. MaximDevice limit for SQl Server 11-11.5 (was: Sybase 2Gb Limit)

4. Where can I find JDBC driver for Sybase 11

5. Where can I find Sybase server 10/11 ?

6. Using Sybase 11 text-fields

7. Using Sybase Central with Sybase SQL Server 11.0.3

8. Parameterized Queries in DTS using SYBASE 11 Driver Version 3.01.00.00

9. Sybase ver. 11/NT - long query canceled

10. history server 11.9.2.1 on Sybase 11.0.3.3

11. Newbie: Sybase ASE 11.9.2 vs 11.5.1

12. Error when upgrading Sybase 11.0.2 to 11.0.3


 
Powered by phpBB® Forum Software