ananda.murugesan (1/28/2012)
In cause of if very big sorting operation or sql jobs are running long time for particular time period that time tempdb will be allocate some contention during this activity
Probably not. Growth maybe, but not contention. Contention comes from lots and lots and lots of small operations, not a single large one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability