January 6, 2014 at 8:15 am
Hi,
I have a SQL 2008 R2 SP2 Enterprise Edition cluster (2 nodes Active/Passive) installed on Windows Server 2008 R2 Enterprise. Each node has a total of 96 Gb installed and SQL Servers maximum memory setting for the buffer pool is set to 83 Gb.
I am aware that the amount that sqlservr.exe in task manager may take is more than what is allocated but on this cluster it is currently using 89.5 Gb and there is only 200 Mb of physical memory free in total now. This behaviour was noticed previously so the maximum amount of memory was reduced but it seems to be the more the buffer pool is reduced the sqlservr.exe process utilises what ever else is available.
How can I monitor what is using this extra memory as it is over 6 Gb now and there seems to be intermittent issues on the server which after looking at other performance counters, CPU, disk I/O seem to be OK.
Thanks in advance!
January 6, 2014 at 8:47 am
It'll be SQL Server using that, it's non-buffer memory. Reduce max server memory until you're happy with the available MB.
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
January 6, 2014 at 9:02 am
Thanks Gail, is there any way of monitoring what is actually using this non-buffer memory though as it does seem excessive at over 6 Gb. From what i've read it may be extended stored procedures, CLR etc but unfortunately I do not know much about the application using this SQL instance.
January 6, 2014 at 9:12 am
Backup buffers, thread stacks, linked server drivers, CLR, few other things too.
Chapter 4 - https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply