cancel
Showing results for 
Search instead for 
Did you mean: 

sp_helpsegment pages don't add up. How can I fix this?

Former Member
0 Kudos

I'm trying to use sp_helpsegment to determine how full the transaction log is. It seems one would expect 'used_pages' + 'free_pages' = 'total_pages'. However, this is not the case with my results. Am I misinterpreting the meaning of these fields, or is the data stale? If it is stale, is there some command I can run to refresh the data?

Former Member
0 Kudos

Certainly, see below:

segment   name            status

2              logsegment   0

device     size

master    26.0MB

free_pages

128

table_name    index_name    indid      partition_name

syslogs          syslogs          0           syslogs_8

table_name    index_name    indid

syslogs         syslogs           0

total_size   total_pages  free_pages   used_pages   reserved_pages

26.0MB      6656           128              3315              0

Accepted Solutions (0)

Answers (0)