Category Line Chart

A category line chart example

The specification for this chart

<result>
	<sql>
		SELECT rtrim(ltrim(instance_name)) "Type", cntr_value "Value" 
		FROM sys.dm_os_performance_counters
		where counter_name like  'Lock Requests/sec%' and instance_name in (
		select top 6 instance_name FROM sys.dm_os_performance_counters 
		where counter_name like 'Lock Requests/sec%' and instance_name != '_Total'
		order by cntr_value desc )
		order by 2 desc
	</sql>
	<result-type>GRAPHICAL</result-type>
	<graphical>
		<title>Lock requests (top 5)</title>
		<interval>6</interval>
		<dynamic>true</dynamic>
                <functions>
                    <function>negative_to_last</function>
                </functions>
                <resultset>
			<column>
				<name>Type</name>
				<sql-type>1</sql-type>
                        	<diff>1</diff>
			<label/>
			</column>
			<column>
				<name>Value</name>
				<sql-type>1</sql-type>
                        	<diff>1</diff>
				<label/>
			</column>
		</resultset>
		<category-line-chart>
			<to-plot>Value</to-plot>
			<chart-type>3</chart-type>
			<categories>Type</categories>
		</category-line-chart>
	</graphical>
</result>

← Category Chart / dbWatch Monitoring and Reporting →