Home > ASE > Database device and segment

Database device and segment

For Adaptive Server, devices provide a logical map of a database to physical storage, while segments provide a logical map of database objects to devices.

Adaptive Server keeps track of the various pieces of each database in master.dbo.sysusages. Each entry in sysusages describes one fragment of a database. Fragments are a contiguous group of logical pages, all on the same
device, that permit storage for the same group of segments. Fragments are also known as “disk pieces.”


Check the Sybase Wiki @
Categories: ASE Tags:
  1. No comments yet.
  1. No trackbacks yet.