Post reply

How can we see cpu utilization

  • April 8, 2008 at 8:36 am

    #120850

    Hi,

    Will u plz tell me how can we see os performance in sql server query .Bcause i need to see cpu utilization ,and database space , disk space i dont know how to find it i am trying to see by this query

    SELECT

    (Physical_memory_in_bytes/1024.0)/1024.0 AS Physical_memory_in_Mb

    FROM

    sys.dm_os_sys_info

    but this query shows me only physical used memory of cpu i just want to see utilization of disk space like with ssms we can see all details with summary .but i want to see with sql server query

    thaxxx

  • April 8, 2008 at 11:39 am

    #799926

    Try this.

    select

    (sum(awe_allocated_kb)/1024)

    from

    sys.dm_os_memory_clerks

  • April 8, 2008 at 12:35 pm

    #799957

    for cpu utilization, see my response in:

    http://qa.sqlservercentral.com/Forums/Topic480117-360-1.aspx

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply