on 05-02-2014 8:09 PM
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?
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.