• 1. any query uses group by , order by etc.. uses tempdb.

    so if view contains that tempdb will use

    2. no of physical cpu = no of tempdb files.