Author Archives: ponciroli

TCP Chimney and RSS

http://support.microsoft.com/kb/951037/en-us
These should be disabled on VMWare servers.

How to configure TCP Chimney Offload in the operating system

  • To enable TCP Chimney Offload, follow these steps:
    1. Use administrative credentials to open a command prompt.
    2. At the command prompt, type the following command, and then press ENTER:
      netsh int tcp set global chimney=enabled
  • To disable TCP Chimney Offload, follow these steps:
    1. Use administrative credentials to open a command prompt.
    2. At the command prompt, type the following command, and then press ENTER:
      netsh int tcp set global chimney=disabled
  • To determine the current status of TCP Chimney Offload, follow these steps:
    1. Use administrative credentials to open a command prompt.
    2. At the command prompt, type the following command, and then press ENTER:
      netsh int tcp show global

How to enable and disable RSS in Windows Server 2008

To enable RSS, follow these steps:

  1. Use administrative credentials to open a command prompt.
  2. At the command prompt, type the following command, and then press ENTER:
    netsh int tcp set global rss=enabled

To disable RSS, follow these steps:

  1. Use administrative credentials to open a command prompt.
  2. At the command prompt, type the following command, and then press ENTER:
    netsh int tcp set global rss=disabled

To determine the current status of RSS, follow these steps:

  1. Use administrative credentials to open a command prompt.
  2. At the command prompt, type the following command, and then press ENTER:
    netsh int tcp show global

 

 

 

Run from command prompt to return TCP Chimney info:  netsh interface tcp show global

 

 

This article says keep RSS on for Windows 2008 R2: http://www.windowsitpro.com/article/networking/give-microsofts-scalable-networking-pack-140350

 

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/01a501bb-ff35-4fc8-8e3e-481926471c8a

 

Windows 2008 – TCP Chimney Offload – http://support.microsoft.com/kb/951037

 

 

TCPChimney article:

http://blogs.msdn.com/b/psssql/archive/2008/10/01/windows-scalable-networking-pack-possible-performance-and-concurrency-impacts-to-sql-server-workloads.aspx

 

 

Disable RSS and TCP offload:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;948496

To manually disable RSS and TCP Offload yourself, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate the following registry subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

  1. Right-click EnableTCPChimney, and then click Modify.
  2. In the Value data box, type 0, and then click OK.
  3. Right-click EnableRSS, and then click Modify.
  4. In the Value data box, type 0, and then click OK.
  5. Right-click EnableTCPA, and then click Modify.
  6. In the Value data box, type 0, and then click OK.
  7. Exit Registry Editor, and then restart the computer.

Disable TCP Chimney:

Netsh int ip set chimney disabled

Disable RSS:

Set EnableRSS DWORD value to 0 in the following key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

Windows Server 2012 memory limitations

http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#physical_memory_limits_windows_server_2012

Physical Memory Limits: Windows Server 2012

The following table specifies the limits on physical memory for Windows Server 2012.      Windows Server 2012 is available only in X64 editions.

Version Limit on X64
Windows Server 2012 Datacenter 4 TB
Windows Server 2012 Standard 4 TB
Windows Server 2012 Essentials 64 GB
Windows Server 2012 Foundation 32 GB
Windows Storage Server 2012 Workgroup 32 GB
Windows Storage Server 2012 Standard 4 TB
Hyper-V Server 2012 4 TB

 

SQL Server 2012 Features By Edition

The BI edition is the same as enterprise for the AS and RS resources.

http://msdn.microsoft.com/en-us/library/cc645993.aspx


Cross-Box Scale Limits


Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1 Operating System maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores
Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1 Operating system maximum Operating system maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores
Maximum memory utilized (per instance of SQL Server Database Engine) Operating system maximum 64 GB 64 GB 64 GB 1 GB 1 GB 1 GB
Maximum memory utilized (per instance of Analysis Services) Operating system maximum Operating system maximum 64 GB N/A N/A N/A N/A
Maximum memory utilized (per instance of Reporting Services) Operating system maximum Operating system maximum 64 GB 64 GB 4 GB N/A N/A
Maximum relational Database size 524 PB 524 PB 524 PB 524 PB 10 GB 10 GB 10 GB

1Enterprise Edition with Server + Client Access License (CAL) based licensing is limited to a maximum of 20 cores per SQL Server instance. For more information, see Compute Capacity Limits by Edition of SQL Server.