[sql2000]
i want to put tempdb on some realy fast device, but device is limited with
size.

my question is how to determine the maximum size temdb may grow [since it
grows dymamicaly, there is no fixed value]?

i would like to examine some logs, to see what was the largest tempdbf size
in the past, is it possible?
if not, i may put permanent monitor on tempdb folder to watch the size of
that file during some long period.
is there some more sophisticated method?

thnx.

Hi,

SQL Server will not log the growth of any database in system tables. But
from SP4 onwards it just mark an entry stating that Autogrow happened inside
SQL Server error log.
But auto grow during online is a high resource intensive task and can even
logoff connected users. So I recommend you to analyze your application and
provide a higher Tempdb MDF and LDF size; so as auto growth will not happen.
Take a look into profiler on Autogrow event..

Thanks
Hari

"sali" <sali@euroherc.hr> wrote in message
news:u9wDaoxBHHA.1300@TK2MSFTNGP03.phx.gbl...
> [sql2000]
> i want to put tempdb on some realy fast device, but device is limited with
> size.
>
> my question is how to determine the maximum size temdb may grow [since it
> grows dymamicaly, there is no fixed value]?
>
> i would like to examine some logs, to see what was the largest tempdbf
> size in the past, is it possible?
> if not, i may put permanent monitor on tempdb folder to watch the size of
> that file during some long period.
> is there some more sophisticated method?
>
> thnx.
>