Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Increase tempdb database, SQL 2008 R2
Date: Thu, 22 Dec 2011 23:28:40 +0100
Organization: Erland Sommarskog
Lines: 17
Message-ID: <Xns9FC3EED4A976CYazorman@127.0.0.1>
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> <jcv8m5$27o$1@gregory.bnet.hr>
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="17663"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19aBik5Ud/krwBP2vsjUYBk"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:iEOSeBu1IbgsGhDFUmLetq0S54w=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:886

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