MS SQL Server - TEMPDB is growing

Author

TEMPDB is growing

Ali Grey

2006-02-03, 11:23 am

Hi,

We have a fairly large SQL Server installation and we have noticed recenlty
that the TEBMPDB is growing.

Can someone tell me why this would be the case? What makes TEMPDB grow?

We are using SQL Server 2000.

Yours
AliG

Tibor Karaszi

2006-02-03, 11:23 am

Here's a good start: http://aspfaq.com/show.asp?id=2446

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Ali Grey" <agrey12@aol.com> wrote in message news:e%23YiypNKGHA.3164@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> We have a fairly large SQL Server installation and we have noticed recenlty
> that the TEBMPDB is growing.
>
> Can someone tell me why this would be the case? What makes TEMPDB grow?
>
> We are using SQL Server 2000.
>
>
> Yours
> AliG

Paul Cahill

2006-02-17, 9:23 am

Is it the tempdb log that is growing?
If so then maybe.....

From Andrew J. Kelly SQL MVP

See if this is your issue:
http://www.kbalertz.com/Feedback_909369.aspx

--
Andrew J. Kelly SQL MVP

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:eOYZZwNKGHA.668@TK2MSFTNGP11.phx.gbl...[color=darkred]
> Here's a good start: http://aspfaq.com/show.asp?id=2446
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "Ali Grey" <agrey12@aol.com> wrote in message
> news:e%23YiypNKGHA.3164@TK2MSFTNGP11.phx.gbl...

Sponsored Links