Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Can anyone think of a reason dbstop may take a long time to run, with high CPU?

Is it likely to be the final CHECKPOINT, and if so, why?

All the properties and options look normal, but (alas) I don't have realtime access to the servers.

asked 01 Feb '18, 07:47

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Wow, where is that "ancient" tag? :)

(01 Feb '18, 07:52) Volker Barth

is it possible to stop DB with SQL? (I don't know)

(01 Feb '18, 11:14) Vlad
Replies hidden

STOP ENGINE engine-name UNCONDITIONALLY; ...which does exist in V5.5.

I will suggest it, thanks.

(01 Feb '18, 11:18) Breck Carter

Shutting down also disconnects & rolls back all transactions. If you have a very large uncommitted transaction, it can take a long time to roll it back.

I would normally expect checkpoints to be IO intensive rather than CPU intensive. If you still suspect the checkpoint, are they using an SSD and an enormous cache? These seem unlikely since they are using 5.x software... In any case, IO to SSD is fast enough that you would probably see lots of CPU and you'd need an enormous (and very dirty) cache to make the checkpoint take a long time. You could try to do a manual checkpoint before shutting down and seeing if you observe the same high-cpu behaviour.

I think the rollback is more likely.

permanent link

answered 01 Feb '18, 11:25

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%


> large uncommitted transaction

Yes, of course, excellent!

I am guessing that a large SELECT PROPERTY ( 'RollbackLogPages' ) would predict a slow dbstop, correct?

(yes, normally that's a DB_PROPERTY thing, but not in 5.5 :)

(01 Feb '18, 12:53) Breck Carter
Replies hidden

Inevitable suggestion: I'd recommend to test with the latest 5.5.05 EBF, 5.5.04 is so old:)

(01 Feb '18, 13:56) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 01 Feb '18, 07:47

question was seen: 1,150 times

last updated: 01 Feb '18, 13:56

Related questions