| Author |
tempdb size increases
|
|
| Tom Reis 2005-11-29, 9:23 am |
| I have a SQL 2000 Server with SP4 where the tempdb seems to be growing at a
alarming rate and now it is at about 2GB. Is there a way to view what is in
the tempdb?
| |
| Armando Prato 2005-11-29, 1:23 pm |
|
You can look inside the sysobjects table of tempdb to see what objects are
being created
ie
select * from tempdb..sysobjects
"Tom Reis" <reistom@cdnet.cod.edu> wrote in message
news:efL38NP9FHA.3532@TK2MSFTNGP14.phx.gbl...
> I have a SQL 2000 Server with SP4 where the tempdb seems to be growing at
a
> alarming rate and now it is at about 2GB. Is there a way to view what is
in
> the tempdb?
>
>
| |
| Bud Y. Zer 2005-11-29, 8:23 pm |
| Use GOOGLE. This question has been posted a million (milliard) times
before!
"Tom Reis" <reistom@cdnet.cod.edu> wrote in message
news:efL38NP9FHA.3532@TK2MSFTNGP14.phx.gbl...
>I have a SQL 2000 Server with SP4 where the tempdb seems to be growing at a
> alarming rate and now it is at about 2GB. Is there a way to view what is
> in
> the tempdb?
>
>
|
|
|
|