SQL Server Performance

Windows Server Netowrk Setting for Sql Server

Discussion in 'Performance Tuning for DBAs' started by seanlo@jdg.co.za, Oct 19, 2005.

  1. seanlo@jdg.co.za New Member

    Hi There

    Recently i came across a micrisoft press book that had the following general setting for a Sql Server Database Server running on WIndows Server 2003.

    They said under LAN properties "File and Printer Sharing for Microsoft Networks" must be ticked and should be by default, and then under that select maximize data throughput for network applications.

    It said Sql Server should automitically make this setting.

    On our production server which is in a cluster i see "File and Printer Sharing for Microsoft Networks" is not even selected , only Intel Network Services Protocol.

    Does anyone know about this ? Perhaps the Press book was old, as it was refferring to Wondows 2000 not 2003.

    Can anyone tell me if this setting should be taken on the database server, ro if i can leave it as is ?

    Thanx
  2. satya Moderator

    http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/bcdae91f-537c-4707-8fae-1eec88190837.mspx link for your information.

    Can you link the specification of this settting must be affected on SQL Server also, to my knowledge I never enabled this option on our production servers.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. seanlo@jdg.co.za New Member

    Hi Satya

    Thanx for the response.

    But the article does not say anything about whether this setting is reccomended for a sql server database server, also this setting is not even selected on my server and it is running fine, so i am not sure to leave it alone or look into taking this setting.

    The article says how to do it which i know but not when you should do it ?

    Thanx
  4. ghemant Moderator

    Hi,<br /><br />Its not necessary to enabled this option unless you wants to share folders / resources on your SQL Box, "Read File and Printer Sharing for Microsoft Networks" in Windows Help .<br />so dont worry about this option.<br /><br />HTH<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  5. seanlo@jdg.co.za New Member

    Hi

    Cool, that is all i needed to know, thanx a million

    Thanx
  6. ghemant Moderator

    Hi,<br /><br />Most Welcome <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  7. satya Moderator

    Thats why I referred that article about no reference on the SQL server about this configuration.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. seanlo@jdg.co.za New Member

    Cool, thanx satya

Share This Page