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

Re: Increase tempdb database, SQL 2008 R2

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!newsfeed.CARNet.hr!garrison.bnet.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 09:59:51 +0100
Organization	B.net Hrvatska d.o.o.
Lines	29
Message-ID	<jcuri7$e6j$1@gregory.bnet.hr> (permalink)
References	<jcstpv$k1e$1@gregory.bnet.hr> <jct0hl$dis$1@dont-email.me> <jcum1j$66p$1@gregory.bnet.hr> <Xns9FC363373690EYazorman@127.0.0.1>
NNTP-Posting-Host	83.139.114.5
X-Trace	gregory.bnet.hr 1324544391 14547 83.139.114.5 (22 Dec 2011 08:59:51 GMT)
X-Complaints-To	abuse@globalnet.hr
NNTP-Posting-Date	Thu, 22 Dec 2011 08:59:51 +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:883

Show key headers only | View raw

Thank you.

Regards

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message 
news:Xns9FC363373690EYazorman@127.0.0.1...
>m (web12master@gmail.com) writes:
>> 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?
>
> Even without instant file initialization, clearing 200 MB of disk is not
> that painful. Go for it.
>
> -- 
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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