I am using SqlServer 2008 R2 Express edition. When i execute below query i will get all 0 .
select * from sys.dm_os_performance_counters where object_name = 'SQLServer:Resource Pool Stats'
By referring this Link - In express edition I can't use this query to get resource statistics.
But is there any other method to get the resource statistics in SQL Express edition?