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" 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: References: 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 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" 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.