Post reply

Tempdb GROWS

  • May 11, 2010 at 7:18 am

    #1165521

    just to add to that, the free space in the tempdb

    @ 02:20 = 37.4Gb

    @ 02:30 = 34.4Gb

    @ 02:40 = 30.8Gb

    @ 02:50 = 25.6Gb

    @ 03:00 = 18.8Gb

    @ 03:10 = 9.2Gb

    @ 03:15 = 6.1Gb *LOWEST*

    @ 03:20 = 8.1Gb

    @ 03:25 = 25.7Gb

    I will checking further in this time frame to see what else I can pick up ...

    got the above info with george sibbald suggestion on the 1st page of this thread ;-);-)

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • May 11, 2010 at 10:29 am

    #1165673

    Grant Fritchey (5/11/2010)

    Several of those queries are loading data into temporary tables and then loading the same data into permanent tables. Why? Can't they just run the query to move the data into permanent tables? I don't know if that's the principal cause of tempdb growth, but it sure isn't helping. Why write and read the data twice?

    That's the same thing that I noted. The three middle queries are most likely your real problems. I would look at changing those up and optimizing them.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 11, 2010 at 4:44 pm

    #1165879

    Hi 2cams,

    What events and columns you selected while running the Profiler to capture the T-sql that causing the tempdb growth?

    did you use server side trace? or Profiler GUI?

    Thanks

  • May 12, 2010 at 2:20 am

    #1166006

    Profiler Gui ... the TextData column has the sql text in it ...

    I'm awaiting response from the vendor but every response thus far are 1 liner emails :ermm: :ermm:

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • May 12, 2010 at 10:27 am

    #1166359

    Which template to use like standard (default), tsql, tsql_duration?

  • May 13, 2010 at 12:56 am

    #1166663

    I just used the Standard (Default) template ... and populated a table with the results to query it.

    Just for some extra info, this DB SQL2005 Instance (Default) is on SP3

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

  • January 20, 2011 at 9:37 pm

    #1276362

    Hi

    Can anybody understand me the architecture of tempdb in sql server 2005 ?

    Thanks in advance.

  • January 21, 2011 at 4:49 am

    #1276468

    beejug1983 (1/20/2011)

    Hi

    Can anybody understand me the architecture of tempdb in sql server 2005 ?

    Thanks in advance.

    Please post your question as a new thread.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 8 posts - 61 through 67 (of 67 total)

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