Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Increase tempdb database, SQL 2008 R2 Date: Wed, 21 Dec 2011 23:36:46 +0100 Organization: Erland Sommarskog Lines: 16 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="26813"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+KqknnKl7RYmoNXI6ajd9H" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:ekVQKdhz9dc/tR6syjaWHTmUC/c= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:880 m (web12master@gmail.com) writes: > 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? If the service account does not have the Windows permission Perform Volume Maintenance Tasks, SQL Server needs to clear all pages in the newly allocated space, and that will take resources. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx