July 9, 2010 at 8:01 am
Hi All,
SQL2K5 64-bit Standard Edition Consumes more memory than Max Memory Value which is configured on sp_configure. I followed this on Task Manager sqlservr.exe exceeds
Yesterday, I encountered a SQL2K5 Instance, in a short time period, it reaches to Max Memory Value(configured on sp_configure),
Then I did SP update, BIOS/Firmware Update, configured Virtual Memory, Set Max and Min Memory values to a fixed value(16 GB Total Server Memory, 13 GB Sql Server Memory)
After Updates, The Exceed run slowly, but today it reached MAX Server Memory(configured with sp_configure) and exceed this value in Task Manager.
All Performance Counters are Steady and OS is up to date.
What will be the problem?
Please Response this urgently...
Regards,
July 9, 2010 at 2:01 pm
What are the exact values you are using to specify the max memory? How are you determining how much memory SQL Server is using?
You should use perfmon to determine the actual usage - instead of task manager. Task manager doesn't report it correctly.
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 10, 2010 at 2:27 pm
Hi Jeffrey,
I set 13 GB of 16 GB to SQL Server, sqlservr.exe exceeds 15GB in a short time.
Page Read/sec still does lots of Peaks after index rebuild?
Could i check storage?
July 10, 2010 at 2:34 pm
Okay - I'll ask this again what are the exact values you used to set max memory. To clarify my concern is that a lot of people have set that value to: 13631488 thinking this is 13GB. This is not, when setting max memory - that is 13TB.
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 10, 2010 at 3:49 pm
Max Server Memory (MBs) 13312
Min Server Memory (MBs) 13312
July 10, 2010 at 7:47 pm
Max Server Memory (MBs) 13312
The max server memory is the maximum memory used by the buffer pool of SQL Server Database Engine. SQL Server has internal and external components, which can allocate memory outside of the buffer pool and consume additional memory. Therefore, SQL Server as a process acquires more memory than specified by max server memory option.
July 10, 2010 at 8:11 pm
thinknight (7/10/2010)
Max Server Memory (MBs) 13312Min Server Memory (MBs) 13312
Thanks - at least that clears up whether or not that is set correctly. Now, I wouldn't set min = max as that can cause issues and prevent SQL Server and Windows from managing memory efficiently.
If this is a dedicated box, then there is no reason to set the min at all.
The additional memory above the max memory is going to be due to other usage. Do you use a lot of CLR procedures, or external procedures? Those all utilize SQL Server memory and could be your issue.
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply