hi go to http://www.sqlservercentral.com/Forums/Topic910208-146-1.aspx there are a few techniques in the link to check whats up with the tempdb.

If you searched on this forum you would have picked up...

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

Try this http://www.sqlservercentral.com/articles/Log+growth/69476/ and let it run every 5 min.

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:

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

@...

I got up @ 2AM to start the trace and will post the top 5 reads and writes queries which IS NOT NULL TestData in the Trace table 1Gb in...

re created the current indexes, we didn't add any new indexes

another tempdb growth issue, this is just on the log file where as mine is on the datafile. Do you know +- what time the issue is happening? I intend...

I ran the query this morning when I saw your post.

The time the Tempdb grows or grew let me rather say is from 02:17 AM until 03:45 AM.

I'll create a...

9424400

5721100

6721100

620000

520000

The Tempdb file is 38.3Gb and the log file is 386Mb...

Will do, I'm going throw the whole thread again and checking all the suggestions again.

Thanks again.

Hi I implemented what the article CirquedeSQLeil suggested. It ran for 2 days and in a previous post is what I found.

I ran the Query MANU-J posted ==> most IO...

Hi this is the vendor's query, it takes from 3min to over an hour from start time to insert time!

So you saying the waits are nothing to worry about...

Hi guys on the 5th, we stopped the Solarwinds application, we restarted the SQL service to flush out the Tempdb and started this app which ran every 5 min. I...

CirquedeSQLeil (4/30/2010)

---

I suggest to find what is causing it to be that big. Gianluca proposed a solution. I'll propose another option - read this article[/url] and try it's...