on 01-31-2014 10:02 PM
Does Sybase SQL Anywhere 16 provide any capability of remotely viewing all content related to an established user session in real time?
I could use "SQL Anywhere Monitor" to do something like this, but I'd want to know what a particular user was looking at not, overall traffic.
Is there a way to use "Application Profiling" or "Application profiling wizard" remotely? Is there a way to get the actions of a particular user this way? Does this tool slow it down?
I think you can see the level of tracking I'd like to be able to use for this database, does anyone have any experience with this? Is it easier on other versions, or do I need to look a different program to run on top of SQL Anywhere 16?
Thanks,
Hi Gabriel,
but I'd want to know what a particular user was looking at not, overall traffic.
Is this to say you'd like to know which SQL is currently running for a connection in real-time? The best way to do this (graphically) is with the SQL Anywhere Console Utility (dbconsole).
---
Before you can see the SQL statements from connections on the server though, you first have to enable "Last Statement" tracking on the database server. This can be done in a few ways:
Once you have 'Remember Last Statement' enabled on the database server, new statements that arrive to the database server from connections will start to be tracked.
---
Once you're connected with the Console Utility, you can then add in the 'laststatement' column for connections to see these statements (File > Options... > Connection Viewer > 'laststatement' 😞
You can then see the active SQL statements in the console (updated as per the connection refresh settings as shown above):
Regards,
Jeff Albion
SAP Active Global Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Application profiling allows you to log profiling data to a different server as part of the setup/configuration.
http://dcx.sybase.com/index.html#sa160/en/dbusage/perform-s-4379192.html
Application profiling does have a performance impact, anywhere from 5-25% depending on the options used when it is enabled.
If you want to, on an ad-hoc basis, see what is happening in a server, you can connect via DBISQL and procedures like sa_conn_info and sa_conn_activity to see what is happening
http://dcx.sybase.com/index.html#sa160/en/dbreference/sa-conn-activity-system-procedure.html*d5e75330
If you turn on the RememberLastStatement option for the server ( "CALL sa_server_option('RememberLastStatement','ON');" ) you can also see the last statement executed by each connection. eg.
SELECT *, DB_NAME( DBNumber ),
CONNECTION_PROPERTY( 'LastStatement', Number )
FROM sa_conn_info( );
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.