If BPASession table is defragmented, then literally an hour later it is fragmented back by 40% or more.
The reason for this behavior is that the table has a clustered index on the sessionid field, which has a unique identifier type
When a new row is ...