Steam cache with storage tiering support