SQL Server Performance

SQL and Token Ring

Discussion in 'Performance Tuning for Hardware Configurations' started by djmaro76, Apr 28, 2005.

  1. djmaro76 New Member

    Anyone have any pros/cons with running applications across a token ring network that use SQL to house the database?
  2. Luis Martin Moderator

    Token ring is the IEEE 802.5 standard that connects computers together in a closed ring. Devices on the ring cannot transmit data until permission is received from the network in the form of an electronic 'token'. The token is a short message that can be passed around the network when the owner is finished. At any time, one node owns the token and is free to send messages. As with Ethernet the messages are packetized. The packet = start_flag + address + header + message + checksum + stop_flag. The message packets circulate around the ring until the addressed recipient receives them. When the sender is finished sending the full message (normally many packets),he sends the token.
    An Ethernet message is sent in packets too. The sending protocol goes like this:
    wait until you see no activity on the network .
    begin sending your message pocket.
    while sending, check simultaneously for interference (another node wants to send data).
    as long as all clear, continue sending your message.
    if you detect interference abort your transmission, wait a random length of time and try again.

    Token ring speed is 4/16 Mbit/sec , Ethernet - 10/100 Mbit/sec
    For more info seehttp://www.flgnetworking.com/usefuli4.html

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


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



  3. djmaro76 New Member

    Thanks Luis.
    One of our clients is running a token ring LAN and they are experiencing slowness and performance issues in our application. Other clients that use ethernet are not having problems.

    I'm just curious if this is something a lot of people have performance problems with. Our client in question has 105 users.

Share This Page