April 16, 2012 at 4:55 am
Dear Friends,
My Company had a server with 4G ram and Available Ram equal 323,232K. when i stop MSSQLServer Service available Ram equal 3,323,232K. why this happend?
i want increase Available Ram when MSSQLServer Service is run?
what i should do?
Best Regards,
Zohreh:cool:
April 16, 2012 at 5:14 am
It means 3gb ram is reserved for SQL Server.
When you stop MSSQL - the 3gb is released.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 16, 2012 at 7:26 am
yes, and i want know why this happen?
April 16, 2012 at 7:34 am
My bet: max server memory is at default levels so essentially you've told SQL it can use all the memory on the server if it wants to. SQL by design uses a lot of memory, it will take any available memory it is allowed to (max server memory setting) and will keep using it until shut down.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2012 at 7:45 am
off course, but when i install sqlserver200o on a PC with 4G RAM, Available memory equal 3.5G and when stop MSSQLServer available memory equal 3.3G .
both SQL Config on node propery are equal (max and min memory value)
why this happend?
April 16, 2012 at 7:53 am
GilaMonster (4/16/2012)
SQL by design uses a lot of memory, it will take any available memory it is allowed to (max server memory setting) and will keep using it until shut down.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2012 at 10:35 pm
GilaMonster (4/16/2012)
GilaMonster (4/16/2012)
SQL by design uses a lot of memory, it will take any available memory it is allowed to (max server memory setting) and will keep using it until shut down.
How can I see the value of "max server memory setting"?
I right click on the server, go to Properties, then choose the Memory Tab. On the server and on the PC, "Dynamically Configure SQL Server memory" is check and the minimum is 0 and the max is 4 (On both the server and the PC)
But when u stop the mssql server on the PC 3.5 is release but stopping the service on the PC does not realse much memory. Can anyone help? I want mssql not to occupy 80% of the memory on the server
The behaviour of msssql is much different on the PC and the Server
April 17, 2012 at 3:21 am
As I have not installed that SQL 2000, would you tell me how and where it has been told to you've use all the memory on the server if it wants. I right click, go to properties and check the memory tab. Is there the right place? If yes, both on the server and a PC also, the max is set to be used (0: min, 4GB:max) but when that sql 2000 is run on the server the mssqlservr gets about 3.5 GB and when it is stopped, it releases that amount, but on the PC, the mssqlservr does not occupy so much memory
April 17, 2012 at 3:31 am
Are you running 64 or 32bit?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 17, 2012 at 3:41 am
32 bit
April 17, 2012 at 3:58 am
on 32bit windows and SQL only recognizes 3GB Physical memory. chances are SQL is using 90% of the 3GB in fact.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 17, 2012 at 4:27 am
The point is that the server is 32 bit and sql 2000 uses 3.5 G of 4 G, on a PC with 4 G RAM, which is also 32 bit, it DOES NOT occupy the 3.5. It occupies about 0.3 G and this is a big difference which causes problems on the server
April 17, 2012 at 4:30 am
How are you checking memory usage?
SQL uses as much memory as it needs. If it's using 3GB memory, it needs 3GB memory or more to do the work it's doing. If it's using too much, reduce max server memory or add more memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 17, 2012 at 5:36 am
When I stop the mssqlservr SERVICE, 3.5 GB is released. That is how I find how much memory is used by the server
April 17, 2012 at 7:51 am
Do you have 2005 Client??
Connect using that, i mean 2005 SSMS check the properties of the server-->memory it will show you the max memory configured for the server.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply