|
Home > Archive > SQL Anywhere Feedback > June 2005 > Allow request level logging for single connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Allow request level logging for single connection
|
|
| Justin Willey 2005-06-27, 7:23 am |
| In situations where one is trying to debug issues in a live database,
potentially with 100s of other users connected, it would be very useful to
be able to start request level logging for a specific connection. At the
moment you have to record everything and then filter it down to the
potentially tiny fraction that is of interest - with all the effect on
performance that that implies.
The idea would be:
call sa_server_option('re
quest_level_logging'
,'sql,connectionid')
;
where connectionid is optional
Justin Willey
| |
| Bruce Hay 2005-06-27, 9:23 am |
| Use sa_server_option('Re
questFilterConn', <conn-id> ).
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
news:42bfd9f2@forums
-1-dub...
> In situations where one is trying to debug issues in a live database,
> potentially with 100s of other users connected, it would be very useful to
> be able to start request level logging for a specific connection. At the
> moment you have to record everything and then filter it down to the
> potentially tiny fraction that is of interest - with all the effect on
> performance that that implies.
>
> The idea would be:
>
> call sa_server_option('re
quest_level_logging'
,'sql,connectionid')
;
>
> where connectionid is optional
>
> Justin Willey
>
>
| |
| Andrew Giulinn 2005-06-27, 8:23 pm |
| Cool! I didn't know about that. I think that may be very useful.
Any idea why that option isn't available to be set where Request Level
Logging is set up in Sybase Central?
Andrew
"Bruce Hay" < h_a_y@i~a~n~y~w~h~e~
r~e.c_o_m> wrote in message
news:42bffc7e@forums
-1-dub...
> Use sa_server_option('Re
questFilterConn', <conn-id> ).
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
>
> "Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
> news:42bfd9f2@forums
-1-dub...
>
>
| |
| Justin Willey 2005-06-29, 9:23 am |
| Just the job, many thanks. We are still using v8 mainly, but another reason
to move to v9
Justin Willey
"Bruce Hay" < h_a_y@i~a~n~y~w~h~e~
r~e.c_o_m> wrote in message
news:42bffc7e@forums
-1-dub...
> Use sa_server_option('Re
questFilterConn', <conn-id> ).
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
>
> "Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
> news:42bfd9f2@forums
-1-dub...
to[color=darkred]
>
>
|
|
|
|
|