Friday, January 27, 2012

" TempDB" space error

I noticed the following error
Error 1101, Serverity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There
are no more pages available in filegroup Default. space
can be create by dorpping objects, adding additional file
or allowing file growth."
Now our " TempDB" is configured with auto filegrowth and
the drive has enogh free space (say more than 20G).
Current TempDB datafile 3G, logfile 1M ( ? is this problem)
Not sure why we got this error. Please help take a look.Thanks john,
I think that's the key. put log as 1M, even though 10%
increase each time, still could not catch up with
transaction.
I will put more. thanks.
Hansen
>--Original Message--
>Hansen
>If your tempdb is 1mb that is almost certainly your
>problem. Even with autogrow, with it starting that small,
>it just can not grow fast enough to keep up with the need
>for it.
>Try 300mb and see how it goes. There is no magic formula
>and depends on your processing, but usually 10% to 20% of
>the size of your largest database is about right. If it's
>not it may at least be able to grow fast enough from that
>start.
>Regards
>John
>.
>

No comments:

Post a Comment