The tile should go a few feet above the showerhead, preferably up to the ceiling. This will give you the most benefits from tiling to the ceiling. If the tile stops before the showerhead, it can be difficult to clean.