Showing posts from August, 2013

CRM 2011 Performance Settings

REGISTRY Disable 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) SQL Max 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 WI