Settings of Windows Server for SQL

  • Hello,

    Do you have any tips for settings of WS? Roles, memory, etc.. ? it can be different betwen performance?

    any link or references for interesting reading?

    thank you for response

  • The best I can suggest is:

    1. Ensure you have exceptions included in you Anti-Virus and Firewall software

    2. Don't install any other processor or memory intensive applications on the same box.

    I am also assuming of course that you hvae size the box properly to begin with.... 😀

  • In most cases, you don't change anything on Windows Server. If there is AV running, you need exceptions for the SQL Server data, backup, log, and error log folders.

    All memory management is performed inside SQL Server. You set a max memory there, and let SQL manage that. No need to change the Windows host OS.

    I wouldn't install any resource intensive apps on the Windows host, but other than that, if you need it to function as a spare DNS or DHCP server, that can work.

  • hello guys,

    I never talk with someone about this, so now I know, thx for response...

  • http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management covers some Windows settings for memory use.

    As other people have said, you also need to consider AV and Firewall settings, amongst other things. For example, on Windows 2012, Power Management settings are also important.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • For the AD user running the SQL Server service and/or the SQL Server Agent service and/or the SQL Server proxy user:

    1) NOT an administrator! Just a regular user.

    2) Group Policy

    gpedit.msc

    Computer Configuration

    Windows Settings

    Security Settings

    Local Policies

    User Rights Assignments

    Act as part of the operating system

    Adjust memory quotas for a process

    Bypass traverse checking -- proxy user use, I think

    Lock pages in memory -- a subject of some debate

    Log on as a service

    Perform volume maintenance tasks -- required for instant file initialization

    Replace a process level token -- proxy user use, I think

Viewing 6 posts - 1 through 5 (of 5 total)

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