cpu_ticks_in_ms

cpu_ticks_in_ms has been removed from sys.dm_os_sys_info
Anyone have any idea if there is any other way to pull cpu level information through SQL?

dashboard. also trying to make my own and want to find a way to display cpu level

yah. I thought soall the silence is deafening!

Hi, Michael:
I've been tinkering with this myself, but I don't understand why you say that cpu_ticks_in_ms from sys.dm_os_sys_info? Am I misunderstanding?
In fact, the usp_Main_GetCPUHistory stored proc (from the performance dashboard) uses this very measure. Why not check it out, and see if you can use it. Hope this helps!
{[<b>edited by:</b> sql_jr at 9:11 AM (GMT -8) on 1 Oct 2008]
MY bad! I thought we were talking SQL 2005, but realized this is 2008 forum.
I guess that sucks!}
However, upon further review, I see in SQL 2008 Book on-line, that they are listed as part of the sys.dm_os_sys_info dmv.

Found this and it helped me when testing the performance dashboard in SQL 2008, so for the reports seem to run without any problems.
see info on this page:
http://blogs.msdn.com/vascov/archiv...rformance-dashboard-with-sql-server-2008.aspx
Gary
RS

Thanks Gary!