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

Re: Increase tempdb database, SQL 2008 R2

From	"m" <web12master@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Increase tempdb database, SQL 2008 R2
Date	2011-12-22 13:43 +0100
Organization	B.net Hrvatska d.o.o.
Message-ID	<jcv8m5$27o$1@gregory.bnet.hr> (permalink)
References	<jcstpv$k1e$1@gregory.bnet.hr> <jct0hl$dis$1@dont-email.me> <jcum1j$66p$1@gregory.bnet.hr> <Xns9FC363373690EYazorman@127.0.0.1> <jcuri7$e6j$1@gregory.bnet.hr>

Show all headers | View raw

Thanks.

We have 8GB RAM on that SQL server.

What do you think if we limit SQL memory to 6GB, would there be any 
improvment on server performance?


"m" <web12master@gmail.com> wrote in message 
news:jcuri7$e6j$1@gregory.bnet.hr...
> Thank you.
>
> Regards
>
> "Erland Sommarskog" <esquel@sommarskog.se> 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
>
>

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