|
Home > Archive > MS SQL Server > October 2005 > tempdb question for OLTP server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
tempdb question for OLTP server
|
|
| quackhandle1975@yahoo.co.uk 2005-10-28, 11:23 am |
| Hi,
I have an OLTP server that is currently going through UAT before going
live in a month or so. Everything has been configured/tuned, etc
howevert I was wondering about the tempdb database.
It resides on a drive different to all the OLTP databases and currently
the sizes are:
datafile 81MB Allocated Autogrow ON by 10% Unrestricted File Growth
log file 24MB Allocated Autogrow ON by 10% Unrestricted File Growth
Once the OLTP system is fully live only one database will be performing
the majority of the transactions (about 50-100K a day), most tables in
the DB are fairly small (largest is 4.5million) indexes will be rebuilt
(DBCC DBREINDEX uses tembdb?) once a week.
My question is, given the about figures I've mentioned could there be
problems further down the line so to speak about not enough space or
allowing unrestricted growth on temdb?
Thanks in advance,
qh
| |
| David Browne 2005-10-28, 1:23 pm |
|
< quackhandle1975@yaho
o.co.uk> wrote in message
news:1130512482.993786.164120@g44g2000cwa.googlegroups.com...
> Hi,
>
> I have an OLTP server that is currently going through UAT before going
> live in a month or so. Everything has been configured/tuned, etc
> howevert I was wondering about the tempdb database.
>
> It resides on a drive different to all the OLTP databases and currently
> the sizes are:
>
> datafile 81MB Allocated Autogrow ON by 10% Unrestricted File Growth
> log file 24MB Allocated Autogrow ON by 10% Unrestricted File Growth
>
> Once the OLTP system is fully live only one database will be performing
> the majority of the transactions (about 50-100K a day), most tables in
> the DB are fairly small (largest is 4.5million) indexes will be rebuilt
> (DBCC DBREINDEX uses tembdb?) once a week.
>
> My question is, given the about figures I've mentioned could there be
> problems further down the line so to speak about not enough space or
> allowing unrestricted growth on temdb?
>
You should make the files much larger to reduce the frequency of file
growth. File growh is expensive and leads to disk fragmentation.
Unrestricted file growth is a good thing, but if you have some idea of how
much storage you'll need in, say, a year, go ahead and size the files
accordingly.
David
|
|
|
|
|