SQL Server Performance

Investigating the System Monito

Discussion in 'Performance Tuning for Hardware Configurations' started by mcosy, Feb 11, 2007.

  1. mcosy New Member

    Hi,

    I found this to see my Hard disk bottleneck.
    In the System Monitor there are five Physical Disk counters for each physical disk contained in the Logical Drive that are key to identifying I/O bottleneck. Each disk should be investigated individually.

    1. Avg. Disk Queue Length is the average number of both read and write requests that were queued for the selected disk during the sample interval.
    2. Avg. Disk sec/Read is the average time, in seconds, of a read of data from the disk.
    3. Avg. Disk sec/Write is the average time, in seconds, of a write of data to the disk.
    4. Disk Reads/sec is the rate of read operations on the disk.
    5. Disk Writes/sec is the rate of write operations on the disk.

    First, on the System Monitor properties window, slide the time interval to only include the period of “slow performance.” Then calculate the I/Os per disk as follows.

    Q1. System Monitor properties window, slide the time interval to only include the period of “slow performance.”

    Where is this ? I can't see anything under System Monitor-Properties?

    Q2. How long we should monitor and which value we should consider( average or maximum)? duration set 1:40?

  2. satya Moderator

    Are you referring to thishttp://www.sql-server-performance.com/sql_server_performance_audit2.asp article?

    If you are having the performance issues and CPU is acting spurios for smaller queries refer tohttp://sqljunkies.com/Article/D1B7C756-4725-4D31-A53D-C0A47976E6BB.scuk link too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page