Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Settings of Windows Server for SQL Expand / Collapse
Author
Message
Posted Saturday, May 18, 2013 12:35 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:50 PM
Points: 268, Visits: 864
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




How to post data/code on a forum to get the best help: Option 1 / Option 2
Post #1454287
Posted Tuesday, May 21, 2013 6:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 5, 2016 7:30 AM
Points: 393, Visits: 753
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....
Post #1454961
Posted Tuesday, May 21, 2013 11:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:04 AM
Points: 33,549, Visits: 17,677
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1455132
Posted Tuesday, May 21, 2013 11:58 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:50 PM
Points: 268, Visits: 864
hello guys,
I never talk with someone about this, so now I know, thx for response...




How to post data/code on a forum to get the best help: Option 1 / Option 2
Post #1455151
Posted Tuesday, May 28, 2013 3:44 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 12:55 PM
Points: 3,008, Visits: 3,621
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 February 2016: now over 36,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1457246
Posted Wednesday, May 29, 2013 11:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, April 29, 2016 11:56 AM
Points: 911, Visits: 2,643
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

Post #1457893
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse