How to know what is filling UpTempdb

Hi all,
I have a question regarding my TempDB,The initial size of
my tempdb was 10MB and it has grown to 250mb in a have day
and then i wanted to test my vb application a simple
stored proc couldn't return a resultset and errored out
saying Query Timed Out ,Then i tried to increse the size
of Tempdb to 1000MB ,now the query runs fine but i want to
know what is filling the tempdb space and how to clean up
without restarting the sql server.
Thanks
Sudhahttp://www.aspfaq.com/2446
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Sudha Reddy" <anonymous@.discussions.microsoft.com> wrote in message
news:17fe301c4499d$54e7b160$a001280a@.phx.gbl...
> Hi all,
> I have a question regarding my TempDB,The initial size of
> my tempdb was 10MB and it has grown to 250mb in a have day
> and then i wanted to test my vb application a simple
> stored proc couldn't return a resultset and errored out
> saying Query Timed Out ,Then i tried to increse the size
> of Tempdb to 1000MB ,now the query runs fine but i want to
> know what is filling the tempdb space and how to clean up
> without restarting the sql server.
> Thanks
> Sudha|||Thanks for the link it helps
>--Original Message--
>http://www.aspfaq.com/2446
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Sudha Reddy" <anonymous@.discussions.microsoft.com> wrote
in message
>news:17fe301c4499d$54e7b160$a001280a@.phx.gbl...
>> Hi all,
>> I have a question regarding my TempDB,The initial size
of
>> my tempdb was 10MB and it has grown to 250mb in a have
day
>> and then i wanted to test my vb application a simple
>> stored proc couldn't return a resultset and errored out
>> saying Query Timed Out ,Then i tried to increse the size
>> of Tempdb to 1000MB ,now the query runs fine but i want
to
>> know what is filling the tempdb space and how to clean
up
>> without restarting the sql server.
>> Thanks
>> Sudha
>
>.
>