SQL Server Performance

Tempdb and RAID 0

Discussion in 'Performance Tuning for Hardware Configurations' started by pmackay, Sep 13, 2005.

  1. pmackay New Member

    Hi,

    a few days ago I read this topic http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3052, where someone ask about a raid configuration, and Brad and Luis agree that this configuration is a dreamt one. In the array E, he proposed a RAID0 for the tempdb. Yesterday, I saw the same idea in another place.

    Well, I understand that RAID0 is the fastest array for writing, but what happen with the availability of the sqlserver if one or the hard disk fails?

    Thanks

    Patrick MacKAY
    ASP.NET MVP
    pmackay, Sep 13, 2005
    #2

  2. satya Moderator

    satya, Sep 13, 2005
    #2

  3. pmackay New Member

    Great thanks.

    Sometimes the information is there.....and we not see it.



    Patrick MacKAY
    ASP.NET MVP
    pmackay, Sep 13, 2005
    #2

  4. satya Moderator

    In this case it may not be, as it is an archived post [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
    satya, Sep 13, 2005
    #2

Share This Page