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

Re: Increase tempdb database, SQL 2008 R2

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Increase tempdb database, SQL 2008 R2
Date	2011-12-21 23:36 +0100
Organization	Erland Sommarskog
Message-ID	<Xns9FC2F033B9B4CYazorman@127.0.0.1> (permalink)
References	<jcstpv$k1e$1@gregory.bnet.hr>

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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