Hi All,

As far as I know, there is a recommendation that the size of the database page and the size of the cluster (sector) of the file system (for example, NTFS) where the database is located are the same. Thanks to this, when reading one database page, there will be only one access to one sector of the file system.

As I understand it, this recommendation is definitely relevant when it comes to HDD.

Questions:

1) Is this recommendation relevant if the database is located on an SSD ?

2) Is this recommendation relevant if the database is located inside a virtual machine somewhere in a data center ?

asked 24 Jan, 01:46

Stalker's gravatar image

Stalker
515293151
accept rate: 11%


Mark has answered that some months ago here including a link to his older, more detailed answer.

Note, I am absolutely no expert on that topic - but in my understanding even with SSDs, it's an disadvantage when page size is smaller than FS sector size: When it comes to writing, inevitably more data has to be re-written than necessary (i.e. a full sector, not only the modified database page), and that would increase the risk of SSD wear-out. Whether that is a real concern or not will depend on the particular SSDs and the frequency of repeated writes to the same pages...

permanent link

answered 25 Jan, 02:53

Volker%20Barth's gravatar image

Volker Barth
40.0k361549819
accept rate: 34%

edited 25 Jan, 02:53

Thanks for the link, I'll read it.

But what if it’s the other way around, that is, the size of the database page (for example, 16 kb)) is larger than the size of the cluster (sector) of the file system (for example, NTFS 4 kb)?

I am interested in this with the goal of reducing the load (read-write operations) on the hard drive.

(25 Jan, 06:52) Stalker
Replies hidden

I think Mark has answered that as well in the linked response. For SSDs, I assume that a page size larger than the FS sector size won't do harm as SSDs will translate all file sectors to their internal (and randomly accessable) blocks, so it won't matter whether the file system needs more than one sector per database page... There's certainly lots of general information on file system sectors vs. SSD blocks.

But as stated, I that's not my area of expertise. :)

(25 Jan, 07:21) 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

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:

×28
×14

question asked: 24 Jan, 01:46

question was seen: 108 times

last updated: 25 Jan, 07:21