Groups > comp.databases.ms-sqlserver > #884

Re: Increase tempdb database, SQL 2008 R2

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Increase tempdb database, SQL 2008 R2
Date	Thu, 22 Dec 2011 06:17:38 -0500
Organization	A noiseless patient Spider
Lines	36
Message-ID	<jcv3kl$9np$1@dont-email.me> (permalink)
References	<jcstpv$k1e$1@gregory.bnet.hr> <jct0hl$dis$1@dont-email.me> <jcum1j$66p$1@gregory.bnet.hr>
Injection-Date	Thu, 22 Dec 2011 11:17:41 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="vQmQhKLKuh0OvmkK+suVIw"; logging-data="9977"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Y2tNuNbfvWZZVTcwKWhB5PgNLUkBDBak="
X-RFC2646	Format=Flowed; Response
X-Antivirus-Status	Clean
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-Antivirus	avast! (VPS 111221-2, 12/21/2011), Outbound message
Cancel-Lock	sha1:dS/NV8LCSjrmMo6atcHBNCCLt8E=
X-Priority	3
X-MSMail-Priority	Normal
X-MIMEOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:884

Show key headers only | View raw

With Autogrow on, the database is already as big as it needs to be 
(depending on how long it's been since the last restart). The size of your 
application database is not really relevant unless you're doing thins like 
sorting in tempdb. Even still, autogrow has already made tempdb as big as it 
needs to be. Why are you blaming tempdb for your sluggish performance? Are 
you noticing that many waits while tempdb is resized?

That said, however, as Erland put it, 200 Mb is nothing. Go for it. Then 
monitor it for a while to see if it remains at 200 Mb.

m wrote:
> We have bad performanse on that SQL server,
> I noticed that tempdb is smaller than it should be (producer of
> software we use on that sql server advice to have inital min 100MB of
> tempdb)
> Now initial size of tempdb is 8MB with 10% of autogrowth and size is
> 90MB and application database is about 4GB.
>
> I'm planing to put inital 200MB with autogrowth 25%
> What do you think?
>
>
> "Bob Barrows" <reb01501@NOyahooSPAM.com> wrote in message
> news:jct0hl$dis$1@dont-email.me...
>> m wrote:
>>> Hello,
>>>
>>> I need to increase tempdb database on SQL Server 2008 R2.
>>>
>>> Can I do it in business hours?
>>> Is there any negative inpact on the system?
>>>
>> Why? Had you trned autogrow off? I believe you can turn it back on
>> without restarting.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-21 16:26 +0100
  Re: Increase tempdb database, SQL 2008 R2 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-12-21 11:12 -0500
    Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-22 08:25 +0100
      Re: Increase tempdb database, SQL 2008 R2 Erland Sommarskog <esquel@sommarskog.se> - 2011-12-22 08:45 +0000
        Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-22 09:59 +0100
          Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-22 13:43 +0100
            Re: Increase tempdb database, SQL 2008 R2 Erland Sommarskog <esquel@sommarskog.se> - 2011-12-22 23:28 +0100
              Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-23 09:23 +0100
            Re: Increase tempdb database, SQL 2008 R2 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-12-23 09:24 -0500
      Re: Increase tempdb database, SQL 2008 R2 "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-12-22 06:17 -0500
  Re: Increase tempdb database, SQL 2008 R2 Erland Sommarskog <esquel@sommarskog.se> - 2011-12-21 23:36 +0100

csiph-web