Skip to Content
0
Former Member
Oct 08, 2015 at 04:23 PM

feedback about a document on data storage and how to track space allocation

52 Views

Hi community,

I just came accross this document on the Web:

http://www.softwaregems.com.au/Documents/Sybase%20GEM%20Documents/Sybase%20Data%20Storage%20&%20Fragmentation.pdf

I helped me understanding how data are stored but I didn't get all the points.

Have you ever read it? and do you have any comments about the content?

Based on it, I'd like to 'see by myself' how data are physically stored depending on the objects ( APL / DOL tables ; CI / NCI ; LOB...).

Could you tell me the command I should use if I want to see, for a 'structure' (table / index / lob...) the allocation unit / oam / page-chain?

i found 'dbcc listoam' but I believe there are others.

Thanks in advance.

Simon