Pie chart example

The specification for this chart

	<sql>select top 10 'type' = replace(A.type, 'MEMOBJ_', ''), 'value' = A.value from ( 
		SELECT type, SUM (cast((pages_in_bytes/1024) as int) )/1024 as "value"
		from master.sys.dm_os_memory_objects
		group by type
		'DATA CACHE', cast(round(count(*)/128.,0) AS int)
		FROM sys.dm_os_buffer_descriptors ) A
		order by 2 desc
		<title>Shows memory objects (top 10) that are currently allocated by SQL Server (in MB)</title>

← Line chart / Category chart →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment