March 18, 2011 at 9:21 pm
I just have a instance got memory pressure. The DBCC MEMORYSTATUS shown the MEMORYCLERK_SQLOPTIMIZER took about 95% buffer pool, i suspect this is not normal.
I am not sure why it took so many memory, could anybody advise how to troubleshooting this problem? Thanks in advance!
March 18, 2011 at 9:21 pm
The instance is SQL Server 2008 R2 RTM version.
March 19, 2011 at 7:12 pm
I have a few questions for you:
Is your sql instance on 32- or 64-bit platform?
What is the RAM on the server?
Is the instance sharing resources with other applications or SQL instances on the same server?
Have you set max-memory explicitly or left it at default value?
In Task Manager, what is the available memory?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 20, 2011 at 8:29 pm
It is 64 bit version and not confiure max server memory. I suspect it is a internal memory pressure issue, not sure whether configure max server memory could fix this.
March 21, 2011 at 6:06 am
Check the "avg page life expectancy" counter.
If it is consistently lower than 300-500 sec, then you definitely have memory pressure.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 21, 2011 at 6:15 am
Marios Philippopoulos (3/19/2011)
I have a few questions for you:Is your sql instance on 32- or 64-bit platform?
What is the RAM on the server?
Is the instance sharing resources with other applications or SQL instances on the same server?
Have you set max-memory explicitly or left it at default value?
In Task Manager, what is the available memory?
Run tis and reply back.
select * from
sys.sysperfinfo
Where counter_name
in('Target Server Memory (KB)','Total Server Memory (KB)')
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply