| Author |
re: sql doesn't grab memory
|
|
|
| Hi Dudes
I recently upgraded my server's memory to 4 gigs. I have
changed the dynamic memory allocation to 3.5 but sql still
only recognizes 1.7 gigs. How can I get sql to grab the
rest. I'm running windows 2000 server. SQL Server 2000.
Appreciate your help.
Cheers.
Jon
| |
| Kael V. Dowdy 2003-10-15, 7:24 am |
| "Jon" <jonathans@oriontele.com> wrote in message news:< 096101c392e7$78313fa0$a301280a
@phx.gbl>...
> Hi Dudes
>
> I recently upgraded my server's memory to 4 gigs. I have
> changed the dynamic memory allocation to 3.5 but sql still
> only recognizes 1.7 gigs. How can I get sql to grab the
> rest. I'm running windows 2000 server. SQL Server 2000.
>
> Appreciate your help.
>
> Cheers.
> Jon
Could be a variety of issues...but check out "Using AWE Memory on
Windows 2000" in SQL BOL if you haven't already.
| |
| Ray Higdon 2003-10-15, 4:24 pm |
| Are you running SQL Enterprise edition? If not, you can not use more than
2gb.
http://www.microsoft.com/sql/evalua...iew/default.asp
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Jon" <jonathans@oriontele.com> wrote in message
news:096101c392e7$78313fa0$a30
1280a@phx.gbl...
> Hi Dudes
>
> I recently upgraded my server's memory to 4 gigs. I have
> changed the dynamic memory allocation to 3.5 but sql still
> only recognizes 1.7 gigs. How can I get sql to grab the
> rest. I'm running windows 2000 server. SQL Server 2000.
>
> Appreciate your help.
>
> Cheers.
> Jon
| |
|
| The 4GB memory space is divided 50/50 OS/Apps.
Using the /3Gb switch on Win2K Advanced will allow a 3GB
app/1GB OS split and allow SQL to use more than 2GB if
you use SQL Enterprise
The AWE switch mentioned in another reply is for >4Gb
memory.
>-----Original Message-----
>Hi Dudes
>
>I recently upgraded my server's memory to 4 gigs. I
have
>changed the dynamic memory allocation to 3.5 but sql
still
>only recognizes 1.7 gigs. How can I get sql to grab the
>rest. I'm running windows 2000 server. SQL Server 2000.
>
>Appreciate your help.
>
>Cheers.
>Jon
>.
>
| |
| Jay Schmitendorf 2003-11-07, 11:24 am |
| SQL Allocates Space as needed, even if you set minimum memory
I hope you set that.
So if you want it write a memory hog. ( 4 clients doing random access to
your biggest table.)
"Jon" <jonathans@oriontele.com> wrote in message
news:096101c392e7$78313fa0$a30
1280a@phx.gbl...
> Hi Dudes
>
> I recently upgraded my server's memory to 4 gigs. I have
> changed the dynamic memory allocation to 3.5 but sql still
> only recognizes 1.7 gigs. How can I get sql to grab the
> rest. I'm running windows 2000 server. SQL Server 2000.
>
> Appreciate your help.
>
> Cheers.
> Jon
|
|
|
|