Post reply

Tempdb sql2005 vs sql2012

  • December 31, 2014 at 2:01 pm

    #294041

    Hi,

    We recently move a few sql servers from sql2005 to sql2012. For an unknown reason, the tempdb on SQL2012 is getting way bigger then on sql2005 (1gb vs 45gb). This is very strange, since the applications hitting these sql servers did not changed at all.

    This is trowing off our storage plans.

    If there something I missed with sql2012?

    Thanks,

  • December 31, 2014 at 5:23 pm

    #1767303

    What, exactly, are you doing with SQL 2012?? Any configurations or usages that you did not do/have on 2005?

    Have you run any DMV queries to determine what is consuming tempdb space?

    Did you update ALL statistics with a full scan after migration?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • January 2, 2015 at 9:36 am

    #1767428

    On top of that, check that you don't have the tempdb files set to grow at some ridiculous rate.

    But no, just out of the gate there's nothing that would increase tempdb activity to that extent. It is being used more and more, but unless you've got something like snapshot isolation turned on it should explode that much.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply