Network Protocals

  • Ryan007

    SSCrazy Eights

    Points: 8273

    Comments posted to this topic are about the item Network Protocals

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • M&M

    SSC-Insane

    Points: 21699

    Nice question to start the week. Apparently, this protocol would be removed in future versions.

    M&M

  • Joy Smith San

    SSC-Insane

    Points: 24877

    I really liked this question. Fact is that I never bothered about protocol never knew what exactly the difference.

    Was not aware about VIA is a deprecated one as well. Went through the link and now clear. Thank for a wonderful question.

  • SQLRNNR

    SSC Guru

    Points: 281243

    Straight forward simple question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • Toreador

    SSChampion

    Points: 11257

    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    And shared memory requires sufficient memory to share 😉

  • Andre Guerreiro

    SSCertifiable

    Points: 7319

    Nice and easy question for a Monday morning.

    Thank you.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    nice and easy question!!!

    thanks!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • rfr.ferrari

    SSCertifiable

    Points: 6879

    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    in QotD, "specific hardware" isn't any network card hardware!!! remember the NUMA configuration, that is "specific hardware" or "specific technology"!

    see this link: http://support.microsoft.com/kb/299641/en-us

    NUMA to SQL 2K8: http://msdn.microsoft.com/en-us/library/ms345357(v=SQL.100).aspx


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • SanDroid

    SSChampion

    Points: 10068

    Nice easy Monday question. Thank you.

    Seriously suprised how many people chose Shared Memory.

  • SanDroid

    SSChampion

    Points: 10068

    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    A Network Card is not considered specialized hardware 😛

    VIA requires very special hardware allowing the server to use kernel bypassing and RDMA in a System Area Network. 😎

  • TomThomson

    SSC Guru

    Points: 104773

    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    It was last time I looked.

    But how about local loopback connections (TCIP to 127.0.0.1:1443)? They used to require an adapter (although whether they actually used it depended on whether the platform software provided software loopback or required an adaptor that would perform loopback) but I'm not sure they do today.

    Tom

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3994

    thanks for the question - nice easy start to the week 😉

  • TomThomson

    SSC Guru

    Points: 104773

    rfr.ferrari (11/7/2011)


    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    in QotD, "specific hardware" isn't any network card hardware!!!

    In what respect are you claiming that this is less specific than VIA hardware? It's any VIA hardware just as it's any Ethernet adaptor - it certainly isn't "any network card" because you would have one hell of a time trying to run IP over an asynchronous connection on a telephone line (unless you put some sot of virtual interface adaptor software beneath IP - that of course is quite common), or over a non-transparent basic mode synchronous connection, or over a synchronous modem connection that doesn't provide any form of framing, or over a 5-bit telex adaptor, or over a SCSI card.

    Tom

Viewing 15 posts - 1 through 15 (of 23 total)

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