From: web12master@gmail.com   
      
   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.   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)