Request level logging can be very useful in seeing what is actually happening in a live database, but the higher levels of logging (eg SQL, PLAN etc) do involve a fair degree of server load - especially with many hundred simultaneous users. Ideally one could just log a single connection but the way the docs read:

Output to the request log can be filtered to include only requests from a specific connection or from a specific database, using the sa_server_option system procedure.

everything (ie for all connections / databases) is being collected (with the consequent server load) but the output is being filtered down to a single user.

Am I reading too much into the word "filtered" or is that the correct interpretation?

asked 10 Mar '15, 09:55

Justin%20Willey's gravatar image

Justin Willey
7.5k136177247
accept rate: 19%


If my understanding of the docs is correct, you should be able to collect only RLL data for a specified connection via

CALL sa_server_option( 'RequestFilterConn', connection-id );

To cite:

RequestFilterConn
Filter the request logging information so that only information for a particular connection is logged. This can help reduce the size of the request log file when monitoring a database server with many active connections or multiple databases.

So in my humble opinion that would mean the data collecion is already filtered, not the later RLL output. - Note, that's just another WAG for today:)

permanent link

answered 10 Mar '15, 10:00

Volker%20Barth's gravatar image

Volker Barth
39.5k355539811
accept rate: 34%

edited 10 Mar '15, 10:03

It isn't absolutely clear is it? The word "logged" could be taken as meaning "only data for a particular connection is written to the log" rather than "only data for a particular connection is collected"

It talks about keeping down the log file size but doesn't mention the server load.

Mmmm.. I may be being paranoid but it doesn't mean they aren't out to get me!

(10 Mar '15, 10:20) Justin Willey
Replies hidden

Yes, after reading the "About Request logging" page I thought it could also be meant as you have expected... - "Suck it and see" is not your preferred choice here, correct?

(10 Mar '15, 10:24) Volker Barth

Not with 700 users all beavering away- no :) It's hard to tell on a quiet system and too late to find out on a busy one when it crashes!

(10 Mar '15, 10:35) Justin Willey

This is an Occam's Razor moment, methinks, as in "take the simple interpretation of 'only information for a particular connection is logged'".

(10 Mar '15, 11:07) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×23
×11

question asked: 10 Mar '15, 09:55

question was seen: 1,647 times

last updated: 10 Mar '15, 11:08