January 25, 2017 at 9:31 am
So if you run the following, it clearly shows which parts of SQL are using the most memory.
SELECT SUM (pages_in_bytes) as 'Bytes Used', type
FROM sys.dm_os_memory_objects
GROUP BY type
ORDER BY 'Bytes Used' DESC;
GO
Does anyone have an article anywhere ( i have searched the net!) for what each 'type' actually is? Specifically MEMOBJ_SOSWORKER
cheers
January 26, 2017 at 9:46 am
Any ideas anyone?
January 26, 2017 at 6:11 pm
SQLAssAS - Thursday, January 26, 2017 9:46 AMAny ideas anyone?
No docs that I could find but for MEMOBJ_SOSWORKER I was guessing its the SOS worker threads.
Run these queries and note the memory_object_address. And the counts.
SELECT *
FROM sys.dm_os_memory_objects
WHERE type like 'MEMOBJ_SOSWORKER'
ORDER BY memory_object_address'
And compare these to the DMV for the worker threads: SELECT memory_object_address, *
FROM sys.dm_os_workers w
ORDER BY w.memory_object_address
Sue
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy