Memory usage shown in Task Manager for SQL Server 2008 is wrong.

Image

After having spent too many hours struggling with high cpu usage for Sql Server 2008, I found out that the related memory usage is wrong. The proper way to know how much memory SQL is using, we simply have to run this query :

SELECT * FROM sys.dm_os_sys_memory DOSM

via stackoverflow / WilliamD



Eric Paré
par Eric Paré
22 juin 2011 - 16:30
A été vu 716 fois





1 Commentaires

Votre commentaire
Nom
Courriel
Adresse de votre site Internet (optionnel)
2 + 8 = ?
Jérémy Lloubes
Jérémy Lloubes
Hum, It is not wrong per se, it rather shows how much memory is allocated to the process as far as my understanding goes :)

I'd compare that to the way Linux systems usually handle RAM, allocating as much of it as possible to speed up resident applications therefore leaving you with the impression that you're running out of memory if you're not checking in "top" application to know how much of the RAM usage is only used for buffers ...

Same goes for SQL Server, it stores as much indexes / views / whatsoever in the amout of memory the system gives to its process.

Not exactly sure for the semantics yet that's the idea. Cool to have the table in which we can get the real amount of memory in use though. Mardi, 20 déc. 2011 à 16:33