You have a SSD that uses a 4 KB page and 64 pages per block. You have a record size of 768 bytes and a file of 100,000 records. Assuming that records do not span page boundaries, how many blocks will the file use?
You have a SSD that uses a 4 KB page and 64 pages per block. If your drive size is 200 GB, how many blocks are there?
With the drive as specified above, if each block can sustain 50000 flashes, what is the maximum life of the drive in block-flashes?
If you are processing 100 million transactions per day, how many of those transactions will cause the record (and its page) to be relocated?
This is a good argument for buffering or caching each page as long as possible. But let's continue to assume no buffering or caching so that each relocation results in a page being moved. How many blocks, at 64 pages per block, will be needed to handle these relocations each day?
How many days of this activity can the drive specified above handle?
Convert the answer above to years (assume 365 days per year)?