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

Re: Increase tempdb database, SQL 2008 R2

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsfeed.tele2net.at!newsfeed.utanet.at!newscore.univie.ac.at!161.53.160.66.MISMATCH!newsfeed.CARNet.hr!gregory.BNet.hr!not-for-mail
From	"m" <web12master@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Increase tempdb database, SQL 2008 R2
Date	Thu, 22 Dec 2011 08:25:39 +0100
Organization	B.net Hrvatska d.o.o.
Lines	27
Message-ID	<jcum1j$66p$1@gregory.bnet.hr> (permalink)
References	<jcstpv$k1e$1@gregory.bnet.hr> <jct0hl$dis$1@dont-email.me>
NNTP-Posting-Host	83.139.114.5
X-Trace	gregory.bnet.hr 1324538739 6361 83.139.114.5 (22 Dec 2011 07:25:39 GMT)
X-Complaints-To	abuse@globalnet.hr
NNTP-Posting-Date	Thu, 22 Dec 2011 07:25:39 +0000 (UTC)
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-RFC2646	Format=Flowed; Original
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:881

Show key headers only | View raw

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