Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:49 PM
Points: 188, Visits: 564
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
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: Sunday, December 14, 2014 11:59 PM
Points: 333, Visits: 555
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: Yesterday @ 5:38 PM
Points: 31,368, Visits: 15,834
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:49 PM
Points: 188, Visits: 564
hello guys,
I never talk with someone about this, so now I know, thx for response...
Post #1455151
Posted Tuesday, May 28, 2013 3:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 2,900, Visits: 3,301
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 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,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: Yesterday @ 9:45 AM
Points: 893, Visits: 2,477
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