Re: Using whole 4GB
- From: "Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx>
- Date: Sat, 06 Jun 2009 12:31:05 -0400
/3G isn't going to do anything. You could try /3GB though. :-)
Then run this:
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure 'max server memory', 3072; -- 3GB
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure 'show advanced options', 0;
RECONFIGURE WITH OVERRIDE;
GO
Reboot and you should be good to go. Also I'm sure you're already aware of
this but don't rely on Task Manager to determine how much memory
sqlservr.exe is utilizing... it lies.
On 6/6/09 12:02 PM, in article
4056CE84-45C0-4D89-B66D-51A977DEFC36@xxxxxxxxxxxxx, "JIM.H."
<JIMH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
sp_configure shows max server memory (MB) as 2GB
I just upgraded memory in the server and did not touch boot.ini. Should I
add /3G?
"Aaron Bertrand [SQL Server MVP]" wrote:
You don't want SQL Server to use all 4GB, you'll need to leave some for the
operating system, in your case probably 1GB is safe.
What does your boot.ini line look like?
What is your sp_configure setting for min/max memory?
A
On 6/6/09 11:34 AM, in article
0421EBBE-6439-4D29-A844-F2B5E8AE45D8@xxxxxxxxxxxxx, "JIM.H."
<JIMH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Using whole 4GB
We are using Windows Server 2003 standard version and SQL Server 2005
Standard version, we have 4GB memory in the server but SQL Server is only
using 2GB, what should I do so it can use all ava8ilabel memory?
.
- Follow-Ups:
- Re: Using whole 4GB
- From: Andrew J. Kelly
- Re: Using whole 4GB
- References:
- Using whole 4GB
- From: JIM.H.
- Re: Using whole 4GB
- From: Aaron Bertrand [SQL Server MVP]
- Re: Using whole 4GB
- From: JIM.H.
- Using whole 4GB
- Prev by Date: Re: Using whole 4GB
- Next by Date: Re: Using whole 4GB
- Previous by thread: Re: Using whole 4GB
- Next by thread: Re: Using whole 4GB
- Index(es):
Relevant Pages
|
