Are there system trace events for checkpoints?

The Event tracing Help topic for 16.0 says this...

"System trace events These are trace events that the database server generates. Trace events are generated for operations such as starting or ending a checkpoint and starting or stopping a database."

... but SELECT * FROM sp_trace_events() doesn't seem to list any events for checkpoints.

performance

asked 31 Mar '13, 10:41

Breck Carter
32.5k●541●726●1050
accept rate: 20%

flat view

One Answer:

active answers oldest answers newest answers popular answers

Currently in 16.0 system trace events exist for request level log, http/https log, and console log. There is no specified system trace event for checkpoints (yet!) but you can use the SYS_ConsoleLog_Information system trace event to capture database checkpoints. You will have to filter the output for checkpoint to retrieve only database checkpoint events.

permanent link

answered 04 Apr '13, 10:39

Mohammed Abo...
971●7●8
accept rate: 37%

If we're talking about kludges, the sa_server_messages() procedure has been around since Version 11, and is more useful because you can SELECT from it... unlike the trace event feature which is only available through a ~~yuck~~ external file. In fact, I'm having a great deal of difficulty figuring out what trace events are good for. Certainly, the Help should not brag about functionality (checkpoint logging) it does not implement.

(04 Apr '13, 15:51) Breck Carter

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

performance ×275

question asked: 31 Mar '13, 10:41

question was seen: 1,062 times

last updated: 04 Apr '13, 15:51

SAP SQL Anywhere

Are there system trace events for checkpoints?

Follow this question

Related questions