InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 06:32:23 GMT20http://www.sqlservercentral.com/Forums/Topic1357039-360-1.aspxYou can also go for a third party tool for the same purpose which will generate a comprehensive report of CPU usage disk space etc which will be helpful to improve the productivity of SQL server !!!!!Thu, 22 Nov 2012 04:45:05 GMTitsmemegamindhttp://www.sqlservercentral.com/Forums/Topic1357039-360-1.aspxSorry this is a old post few months old. Thought I would post the answer in case anyone else ends up here due to a google search.This page has a good explanation of how to query this dmv : http://rtpsqlguy.wordpress.com/2009/08/11/sys-dm_os_performance_counters-explained/I would try something like:select perfCount.object_name, perfCount.counter_name, CASE WHEN perfBase.cntr_value = 0 THEN 0 ELSE (CAST(perfCount.cntr_value AS FLOAT) / perfBase.cntr_value) * 100 END AS cntr_Valuefrom(select * from sys.dm_os_performance_counterswhere object_Name = 'SQLServer:Resource Pool Stats'and counter_name = 'CPU usage %' ) perfCountinner join(select * from sys.dm_os_performance_counterswhere object_Name = 'SQLServer:Resource Pool Stats'and counter_name = 'CPU usage % base') perfBaseon perfCount.Object_name = perfBase.object_nameMon, 05 Nov 2012 14:33:55 GMTcrazyEmuhttp://www.sqlservercentral.com/Forums/Topic1357039-360-1.aspxHi ,Iam collecting a baseline report for one of the sql server instance, where i have only instance level access, dont have access to run the perfmon. Hence i collected details from the DMV - but iam getting values like 1023,2010, some times 0 , 1. How to get the correct percentage of CPU utilised by sql server from this DMV.SQLServer:Resource Pools CPU usage % SELECT * FROM [master].[sys].[dm_os_performance_counters] WHERE ([object_name] = 'SQLServer:Resource Pool Stats' AND [counter_name] = 'CPU usage %')and instance_name ='default'ThanksGKRISHMon, 10 Sep 2012 15:52:06 GMTGopi Krishnan-468302