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

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-23 09:23 +0100
Organization	B.net Hrvatska d.o.o.
Message-ID	<jd1dql$9si$1@gregory.bnet.hr> (permalink)
References	(2 earlier) <jcum1j$66p$1@gregory.bnet.hr> <Xns9FC363373690EYazorman@127.0.0.1> <jcuri7$e6j$1@gregory.bnet.hr> <jcv8m5$27o$1@gregory.bnet.hr> <Xns9FC3EED4A976CYazorman@127.0.0.1>

Show all headers | View raw

This is Microsoft SQL Server Enterprise Edition (64-bit) 2008 R2


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message 
news:Xns9FC3EED4A976CYazorman@127.0.0.1...
>m (web12master@gmail.com) writes:
>> 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?
>
> Since the database is only 4GB, there should be plenty of headroom.
>
> Is this 32-bit or 64-bit SQL Server?
>
> -- 
> 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 | 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