Posts

Showing posts from August, 2013

CRM 2011 Performance Settings

Image
REGISTRYDisable Loopback check
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
           New DWORD Value: DisableLoopbackCheck = 1 (Decimal)
CRM Settings
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
          New DWORD Value: OLEDBTimeout = 86400 (Decimal)
          New DWORD Value: ExtendedTimeout = 1000000 (Decimal)
          New DWORD Value: NormalTimeout = 300000 (Decimal)
          New DWORD Value: AsyncRemoveCompletedWorkflows = 1 (Decimal)
          New DWORD Value: AsyncRemoveCompletedJobs = 1 (Decimal)
TCP/IP Settings
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters
          New DWORD Value: MaxUserPort = 65534 (Decimal)
          New DWORD Value: TcpTimedWaitDelay = 260 (Decimal)
SQLMax Degree of Parallelism and Other SQL Settings
exec sp_configure 'show adv', 1; RECONFIGURE WITH OVERRIDE; --reduces locking by ensureing queries are only run against a single processor exec sp_configure 'max degree', 1; RECONFIGURE WITH OVERRIDE; --reduces ASYNC_…