It is enhanced every time the rogue's sneak attack goes up. Which is every other level.
At 3rd, it's worth 6d6. At 5th, it's worth 8d6. At 7th it's worth 10d6, at 9th it's worth 12d6, etc.
A lot depends on what kind of combats your table favors. The general guidelines seem to suggest the game...