I have a SQL Server 2012 instance using more RAM that it should.
The SQL Server process is using about 22.5GB RAM:
The instance is configured to use a maximum of 10GB:
Which is way more then expected. (It will lead to a server crash and we will have to reboot to get it back).
I checked the memory usage (clerks) with this query:
select type, name, pages_kb/1024.0/1024.0 "size Gb" from sys.dm_os_memory_clerks order by pages_kb desc
SQL Server only seem to see about 7GB RAM being used:
I know it's an old version of SQL Server (and it's not patched to the latest sadly) but I wasn't able to find any clear documentation regarding a memory leak in SQL Server 2012 SP2.
Where should I look to find why SQL Server is using about 200% what it should?
There is a linked server on this instance. A lot using SQL drivers (SQLNCLI and SQLNCLI11) but there is also some using a "PC SOFT OLE DB provider for HFSQL" which I've never seen before.
Is there any way I could 'prove' this driver is the problem? The client will probably not agree to changing the setup based on an assumption, so if there is any way (other then disabling) to clearly show how much RAM is being used by the linked server, that would be priceless.