Performance
of SharePoint Servers
SQL Maxdop setting should NOT be 0
Set
max degree of parallelism (MAXDOP) to 1 for SQL Server instances that host
SharePoint Server 2010 databases to ensure that each request is served by a
single SQL Server process
Anti-Virus check.
Certain
folders may have to be excluded from antivirus scanning when you use a
file-level antivirus program in SharePoint
SQL TempDB configuration and Optimization.
Database maintenance for SharePoint 2010 Products
Disable Certification Revocation checking.
SQL Deadlock errors. Event ID 10016 in logs.
We
need to disable following settings on ALL the SharePoint Servers and also SQL
Servers. If SQL Server is in Cluster, all the nodes in the cluster also needs
to be changed. After making the Changes, Reboot of all the Servers including
SQL servers is Mandatory.
TCP Chimney Offload
By Default in Wind 2008 Servers, this setting is
"Automatic", we need to Disable it. "netsh int tcp set global
chimney=disabled"
http://support.microsoft.com/kb/951037.
http://support.microsoft.com/kb/951037.
IP Task Offload. by Default in Wind
2008 Servers, this setting is "Enabled", we need to disable it.
"netsh int ip set global taskoffload=disabled". This is
also applicable for Fast for SharePoint Server issues.
NIC
settings should be Disabled.
IPv4
Checksum Offload”, “Large Send Offload” and “TCP Checksum offload” [ note:
this may require a hard reboot of the servers ]
Use of Disable TCP Chimney on SQL Servers
