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" 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: References: 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 Thank you. Regards "Erland Sommarskog" 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