yes, this article is very useful even if it has some minor error in it.

I could see witch procedure are running and use tempDB.

Especially query 6 even if it is...

your query is very nice, I use a similar one to bakup all huge table

SELECTgetdate() as tmstmp, o.name as [table_name], MAX(i.rows) AS rows, MAX(crdate) as crdate

FROMtempdb.sys.sysobjects AS o INNER...

I've never used profiler but I'll try,

witch template I should use to perform the test you suggest?

then it look very hard to correlate the sp that make tempDB growing

Is there...

Than you for the query,

but I need more info, because

now tempDB is 20 gb with 98% free space and no chance to shrink it.

I suppose some SP has used lot...

thank you free_mascot,

"dbcc shrinkdatabase (tempdb, 50)" does not work because

tempdb always on.

I've search all the web a solution but it seems impossible to

shrink tempDB without stopping sql service

Does...

thank you for prompt reply.

I'm afraid of your answer! This mean that I have to work hard on t-sql side

or hiding many report and just show the one the...