SQL Server Performance

SQL Server I/O subsystem requirements for tempdb

Discussion in 'Forum Announcements' started by FrankKalis, Apr 18, 2006.

  1. FrankKalis Moderator

    FrankKalis, Apr 18, 2006
    #2

  2. Luis Martin Moderator

    Thanks for share.
    I think is more for 2005 than 7 or 2000.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Apr 18, 2006
    #2

  3. FrankKalis Moderator

    FrankKalis, Apr 18, 2006
    #2

  4. Luis Martin Moderator

    Yes, but I read tempdb in 2005 is more efficient than 2000. That is why I think that.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Apr 18, 2006
    #2

  5. satya Moderator

    I would say this is suitable for both SQL 2000 on high-end systems and SQL 2005 in general.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Apr 18, 2006
    #2

  6. mmarovic Active Member

    Nice follow-up for discussion we recently had.
    mmarovic, Apr 18, 2006
    #2

Share This Page