Hi Jason, Madhu,

Actually its not an issue at all. Initally, I have have allocated the data file size as 10 Gb & ldf file size as 20 GB.

The tempdb log...

Finally I ran the SQL Profile for an hour. Before running the profiler, I stopped the Spot light service.

1. I have selected the standard template with the filter database name...

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

any advice after seeing the tempdb log file growth patteren from the attachment(':hehe:');

thanks

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...

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

You have a process that caused your tempdb to grow to a certain size. Once that process finished, the pages became free. Once a file grows, it will not shrink...

Hi,

I went through the link http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic5015.aspx

where the user Carolyn Godfrey stating the below:

Since tempdb does not require recovery, are there no automatic checkpoints

for tempdb except those when...

Thanks Jason,

Based on the last query you for which you provided results showing the allocation pages, it appears that checkpointing is occurring just fine. The pages are deallocated and freed...

One thing I would like information on is the checkpoint process, suspecting

that the automatic checkpoint is not occurring in TempDB and causing its log file size to increase.

Is there any...

Yes, Still the tempdb log file size increased by 500 MB After stop and starting the Spot light. Is there any process that empty (write the log to data file)...

I ran the same query 'query2' again. But I did not get any high values for internal_objects_alloc_page_count from spot light session.

SELECT top 5 *

FROM sys.dm_db_session_space_usage

ORDER BY (user_objects_alloc_page_count...

It has caused the system to allocate 4.7Gb of pages in the system, though it releases it - that is a lot of activity that seems to be causing your...

From the analysis I done on Tempdb usage (please see the attchment), do you think is there anything unusal tempdb log file growth is happening? In last 24 hours, the...

I have tried to troubleshoot to find why the tempdb log file size is increasing.But I didnot get any clue so far. Please see the attachment.

Thank you