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.

...and can the threshold be changed?

In the following screen snapshot for 12.0.1.3797 the "Space Remaining On Drive" column is highlighted in red, presumably because the space remaining has dropped to 27.6%.

A yellow exclamation icon is also displayed; I don't have the actual screen in front of me so I can't "Click the warning to learn more" as suggested in the Help topic Database health and statistics:

"Dbspaces Displays a table listing all dbspaces. It displays a warning if a dbspace has less than 10% of free disk space remaining, or if a dbspace file cannot be found. Click the warning to learn more."

Yes, there seems to be an inconsistency, between "10%" and "27.6%"... the former seems to be a reasonable default for the threshold, the latter not so much.

...and anyway, this should be available for the user to set.

alt text

asked 08 Jun '13, 09:09

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 08 Jun '13, 09:15


Free space must be at least double the database size or you will get that warning.

permanent link

answered 10 Jun '13, 10:07

PaulTonizzo%20%20SA%20tools's gravatar image

PaulTonizzo ...
516310
accept rate: 31%

So the Help needs fixing, yes?

And no, the "free space must be >= 2x database file size" threshold cannot be changed?

Which means if I have a database that takes up 1/3 of the disk space or more, the alert will ALWAYS be displayed, which makes the alert more-or-less meaningless?

(10 Jun '13, 12:19) Breck Carter

Yes, the help does need a correction and no, the threshold cannot be changed.

(10 Jun '13, 13:46) PaulTonizzo ...
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:

×1

question asked: 08 Jun '13, 09:09

question was seen: 1,820 times

last updated: 10 Jun '13, 17:44

Related questions