Home Forums Article Discussions Article Discussions by Author Discuss content posted by Orlando Colamatteo Has tempdb grown since the last restart? RE: Has tempdb grown since the last restart?

  • November 20, 2012 at 8:30 am

    #1560835

    sql.com (11/20/2012)

    Can you use Extended Events to track TempDB growth? I have read Jonathan Kehayias's article on tracking database growth, I wonder if that can be applied to tempdb too?

    p.s. Nice article, flows and reads well.

    Thanks. I haven't tried it myself but I cannot think of a reason why Extended Events could not be used. I think watching for event sqlserver.databases_log_file_size_changed with filter database_id = 2 so the session only watched tempdb would be where I would begin.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato