SQL Server Performance

Disk array controller Cache

Discussion in 'Performance Tuning for Hardware Configurations' started by aviegas22, Apr 23, 2004.

  1. aviegas22 New Member

    I have Compaq servers with win 2000 and sql server 2000 I have some problems as the clients hang some times having the work stations blocked. I have been told that this could be also due to the disk controller cache. I have been advised to dis-activate the cache. Is this right and can some one advise.

    A Viegas
    aviegas22, Apr 23, 2004
    #2

  2. satya Moderator

    satya, Apr 23, 2004
    #2

  3. Luis Martin Moderator

    Also monitor Hit cache ratio.
    BTW:What kind of RAID do you have?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    Luis Martin, Apr 23, 2004
    #2

  4. gaurav_bindlish New Member

    I agree with Satya on this, if blocking is due to disk controller cache, you should see large disk queue length and large write time during the blocking period.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    gaurav_bindlish, Apr 26, 2004
    #2

  5. derrickleggett New Member

    If you have a good controller, the cache really shouldn't cause the issues you are experiencing. What do you have your cache set at? What are the percents of read/write? What are you seeing on the counters recommended here?

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
    derrickleggett, Apr 26, 2004
    #2

Share This Page