Home Forums SQL Server 2008 SQL Server 2008 Administration allocation page contention in tempDB? RE: allocation page contention in tempDB?

  • January 28, 2012 at 5:08 am

    #1439669

    Thanks SQL Kiwi for your reply..

    SQL Kiwi (1/28/2012)

    Overall, my vote would be for you to leave things as they are, but to continue to monitor for allocation contention, just in case.

    ok, I should continue to monitor for allocation contention in tempdb.

    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 completion after that what will happend? contention should be their in database or automatically will relase once completed these type of Jobs.

    Thanks

    ananda