Disk parameters from DMV

  • Can I get the following information from any Dynamic Management views in SQL

    % Disk Read Time (All Disks)

    % Disk Write Time (All Disks)

    Avg. Disk Bytes/Transfer

    Avg. Disk Queue Length (All Disks)

    Avg. Disk sec/Transfer (All Disks)

    I have data from counters available in sys.dm_os_performance_counters but Disk parameters and processor parameters are not available.

    Can I get similar information from DMV with some manipulation of data??

  • No, just SQL Server counters.

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

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