Helen999888


Hi, all experts here,

Thank you very much for your kind attention.

Just found that my tempdb is always full whenever I run a query against a large database. Could please any experts here give me any advices on what is tempdb database used for and how to determine what files can be deleted from it

I am looking forward to hearing from you and thanks a lot in advance.

With best regards,

Yours sincerely,





Re: Waht is tempdb database used for? and how can we determine what files can be deleted from it?

Rob Farley


tempdb is used for a bunch of stuff - including the storage of data that needs to be stored while a query is running.

It's worth making sure that your tempdb is on a fast disk, and is made large enough to avoid it having to grow. You should never delete data from it - that space will be freed up as soon as the query is over.

Hope this helps - good luck.

Rob






Re: Waht is tempdb database used for? and how can we determine what files can be deleted from it?

Helen999888

Hi, Rob,

Thanks a lot for your very kind advices.

With best regards,

Yours sincerely,