SQL Server Performance


Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by MichaelB, Sep 12, 2008.

  1. MichaelB Member

    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?
  2. satya Moderator

    What problem you are having with PERFORMANCE DASHBOARD REPORTS or using any predefined queries?
  3. MichaelB Member

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

    yah. I thought so:)all the silence is deafening!:)
  5. sql_jr New Member

    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.
  6. GaryRS New Member

  7. MichaelB Member

    Thanks Gary!

Share This Page