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

In V16, specifically.

The real question is, does a DBFileFragments value of 9,000 put the lie to a vendor's claim that "files on the EMC fiber attached SAN SSD setup we installed for you should not be defragmented"?

Note that the vendor says the db file "should not be defragmented", which is different from "doesn't get fragmented"... why more salespeople don't become politicians is beyond me, they seem perfectly adept at answering questions that weren't asked :)

Note also that this is related to (but different from) the long discussion here: What is the Sybase Central 16 "Fragmentation" tab showing?

asked 26 Jul '15, 08:50

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

On Windows, the DBFileFragments value comes from the OS via NtFsControlFile calls with FSCTL_GET_RETRIEVAL_POINTERS ( ).

I cannot say for sure but likely EMC claims that you don't need to defragment files because they may have sufficient caching for most cases. In particular, writes probably go immediately to RAM and they may use a battery back-up to ensure that it eventually all gets written. Having a RAID may also alleviate some of the need to defragment. It's also possible that they do some sector remapping under the covers so that fragments are relocated without Windows knowing. EMC is the only one who could give you an authoritative answer for why they claim that defragmentation is not needed.

permanent link

answered 27 Jul '15, 09:50

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%

edited 27 Jul '15, 13:16

Breck%20Carter's gravatar image

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



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: 26 Jul '15, 08:50

question was seen: 1,759 times

last updated: 27 Jul '15, 13:16