May 18, 2013 at 12:35 pm
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
May 21, 2013 at 6:22 am
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.... 😀
May 21, 2013 at 11:13 am
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.
May 21, 2013 at 11:58 am
hello guys,
I never talk with someone about this, so now I know, thx for response...
May 28, 2013 at 3:44 am
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
May 29, 2013 at 11:51 am
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