Tempdb GROWS

Question

Post reply

Tempdb GROWS

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

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

Feeg SSCrazy Points: 2766 More actions · Answer 1

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

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

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 3

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

Feeg SSCrazy Points: 2766 More actions · Answer 4

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

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 5

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

Feeg SSCrazy Points: 2766 More actions · Answer 6

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

beejug1983 SSCertifiable Points: 6491 More actions · Answer 7

Hi

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

Thanks in advance.

Brandie Tarvin SSC Guru Points: 173053 More actions · Answer 8

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.