July 19, 2009 at 3:23 pm
2147483647 in mb
What does this mean ?
Does it mean that I am only using 2gb ?
I have configure al the required stuff for AWE ie. /pae, loch memory etc.
I am trying to configure the server to use 10gb of RAM.
If I try to run
sp_configure 'max server memory', 2147483648
RECONFIGURE
GO
I get the follwoing error.
Msg 8114, Level 16, State 5, Procedure sp_configure, Line 0
Error converting data type numeric to int.
July 19, 2009 at 4:33 pm
2147483647 in mb
What does this mean ?
Hint: 1024MB = 1GB, 10240 = 10GB and 102400 = 100GB. So, what does that number really mean?
Does it mean that I am only using 2gb ?
Answer your first question and you will have the answer. That is really telling SQL Server to use as much memory as is available on the server.
I have configure al the required stuff for AWE ie. /pae, loch memory etc.
I am trying to configure the server to use 10gb of RAM.
If I try to run
sp_configure 'max server memory', 2147483648
RECONFIGURE
GO
I get the follwoing error.
Msg 8114, Level 16, State 5, Procedure sp_configure, Line 0
Error converting data type numeric to int.
Maybe that is because the number you have tried to use is too large for an integer?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 20, 2009 at 3:23 am
Hi there, thank you for clearing this up.
I have another question though, all my sql2k5 servers seem to have this set as the limit by default.
AWE is not enabled on them.
Does that mean anything, will sql use all the memory on the server ?
July 20, 2009 at 8:51 am
mmaharaj (7/20/2009)
Hi there, thank you for clearing this up.I have another question though, all my sql2k5 servers seem to have this set as the limit by default.
AWE is not enabled on them.
Does that mean anything, will sql use all the memory on the server ?
if the original number 2,147,483,647 is in KB, then the setting says 2048 GB .. otherwise, if it's in GB, it says Terabytes... just a big number I guess!
What "edition" SQL Server you use?
seems I was mistakenly informed by hearsay ... even Standard Edition will use "Operating System Maximum" but max 4 CPU. Workgroup edition is limited to 3GB RAM.
I'll need to have a word with my DBA & SysAdmin now ...
July 20, 2009 at 9:01 am
I am running SQL Server Enterpise Edition.
The value appears as 2147483647 MB, in the memory tab as Maximum server memory.
July 20, 2009 at 9:16 am
mmaharaj (7/20/2009)
I am running SQL Server Enterpise Edition.The value appears as 2147483647 MB, in the memory tab as Maximum server memory.
See my own Edit above ... Standard Ed is not memory-limited by MS.
Check out how much it uses (while running a really big SELECT!) in the Task Manager ... of course, learning how to use Profiler would benefit both of us but the task manager will give you some indication.
I (the Accidental DBA) have inherited my SQL Servers set to max 4GB even though one of the boxes has only 3GB RAM . . .
While running a big one on the server, I have noticed the Task Manager Memory increase to a number in the 300000 before the thing went cactus having used all the available space on the system drive. It writes the tmp file into the logged-on user's Local Settings TEMP.
Hope to read more about AWE and getting more umph out of the thing. ...
July 21, 2009 at 12:33 am
Here we go again . . . to complete the picture above:
on our Win2003 Server Standard 32-bit the memory is limited to 4GB.
Therefore the above clarification becomes : MSSQL2005 Standard on W2K3 Standard 32-bit can use max ... 4GB !
Windows Server 2008 Standard 32bit: 4 GB 64bit: 32 GB
(2003 cannot be any different!)
Any further comments? Can AWE / PAE help in these circumstances?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply