Dropping Event Sessions

Question

Dropping Event Sessions

Steve Jones - SSC Editor

SSC Guru

Points: 736557
More actions
May 6, 2018 at 1:39 am

#77194

Comments posted to this topic are about the item Dropping Event Sessions

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72634 More actions · Answer 1

Nice one to start the week on, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Carlo Romagnano SSC-Insane Points: 22696 More actions · Answer 2

From BOL:
Remarks
When you drop an event session, all configuration information, such as targets and session parameters, is completely removed.

Arno.Hubert.Janssen SSCrazy Points: 2756 More actions · Answer 3

When you stop a session that uses an in-memory target, such as the ring buffer, bucketing, event pairing, or synchronous event counter targets, all the information stored in the session's buffer (the target_data column of the sys.dm_xe_session_targets DMV) will be lost. To access event data after you stop the session, you should either save the data before you stop the session, or configure the session to use the file target.

Steve Jones - SSC Editor SSC Guru Points: 736557 More actions · Answer 4

I'm not sure what the last few posts are meant to mean. If the question or answer wrong? The question asks about the data in the file target, not the ring buffer, not configuration information.

Arno.Hubert.Janssen SSCrazy Points: 2756 More actions · Answer 5

Steve Jones - SSC Editor - Monday, May 7, 2018 8:25 AM
I'm not sure what the last few posts are meant to mean. If the question or answer wrong? The question asks about the data in the file target, not the ring buffer, not configuration information.

It's related to the last sentence in my post "To access event data after you stop the session, you should either save the data before you stop the session, or configure the session to use the file target." Versus the explanation for the correct answer "Data in the file target will persist in the file."

Steve Jones - SSC Editor SSC Guru Points: 736557 More actions · Answer 6

There is a file target. That's the point in the question. It asks about persisting data in the file target, not the ring buffer.

Arno.Hubert.Janssen SSCrazy Points: 2756 More actions · Answer 7

Steve Jones - SSC Editor - Monday, May 7, 2018 8:52 AM
There is a file target. That's the point in the question. It asks about persisting data in the file target, not the ring buffer.

Thanks Steve. I understand now.

IanSinclair SSCertifiable Points: 6132 More actions · Answer 8

If you stop the session - then drop the event - do you not have exactly the same result ?

Steve Jones - SSC Editor SSC Guru Points: 736557 More actions · Answer 9

Dropping the event means the session exists. Dropping the event session removes all the meta data and memory targets, but not the file targets.