September 6, 2006 at 5:52 am
Server configuration : 8Gb ram, 1 DualCore CPU, windows 2003 enterprise R2 (sp1), SQL Server 2000 Enterprise Edition (sp4).
In boot.ini is set /3GB /PAE. In SQL Server AWE is enabled.
I've set max server memory to 7168.
My problem is that only 4 GB is allocated and catn't make it grow. I've tried a lot of combinations from dynamic allocation to fix allocation of 7GB and it dosen't want to allocate more then 4Gb.
Any suggestions ???
September 6, 2006 at 8:19 am
/3gb and > 4gb of ram don't mix well.
My recommendation would be to set boot INI to :
/PAE
SET max server memory to 6xxx (leave 2GB for os functionality) make sure awe is enabled, and then reboot.
Cheers.
dc
September 6, 2006 at 4:35 pm
Are you running Windows 2003? Standard or Enterprise?
September 7, 2006 at 1:30 am
First I've tried only with "/PAE" and it was the same thing. I only put "/3GB /PAE" because I saw an article on this site "AWE Adventures" in with it's say that I should put both "/3GB /PAE". I've olsow tryed with 6GB and it's the same thing.
How can I be soure that "/PAE" is enabled ?
September 7, 2006 at 1:32 am
As you can see in my original post I'm running on "windows 2003 enterprise R2" (is the latest version).
September 7, 2006 at 1:38 am
Did you try seting MIN server memory as well as Max server memory to 6G ?
and then stop/start the sqlserver ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 7, 2006 at 2:13 am
Yep, and I've aloso tried with fix size and still nothing. (yes with stop/start sqlserver).
September 7, 2006 at 2:17 am
Is your /3gb /pae in the first settingsline of your boot.ini
Did doublecheck that this is the active line and that your server is started with these settings !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 7, 2006 at 3:45 am
My boot.ini file :
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /3GB /PAE
September 7, 2006 at 4:18 am
another wild guess : how big is your pageing file(s) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 7, 2006 at 6:14 am
It's 2046 Mb.
September 7, 2006 at 6:15 am
paging file 2046 MB
September 7, 2006 at 6:29 am
Would you mind testing what happens when you make it 8Gb or even 12Gb in total ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 7, 2006 at 7:29 am
I see you have SP4, you know that in SP4 is a bug? You have to install a Hotfix for fixing that problem with AWE (sorry, i don't know the number of hotfix). With the last cumulative update you should have BIULD 2187. Than it works.
September 7, 2006 at 7:47 am
Aarch yes.... the hotfix is "AWE hotfix SQL2000-KB899761-v8.00.2040-x86x64-ENU"
KB904660 has more on the cumulative hotfix.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply