Dynamics CRM 4.0

CRM

Clifford, Chris, Vivien

(Unsupported vs CANNOT)

(planning phase)

(design & implementation phase)

(deployment & maintenance)

Q&A

2

white papers

Optimizing and Maintaining Microsoft Dynamics CRM 4.0

( )http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ba826cee-eddf-4d6e-842d-27fd654ed893

Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008

( )http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b5bb47a4-5ece-4a2a-a9b5-5435264f627d

Suggested Hardware for Deployments of up to 500 Concurrent Users ( )

http://www.microsoft.com/downloads/details.aspx?familyid=3BF7ECDA-7EAF-4F1C-BBFE-CAE19BC8BB78&displaylang=en

3

=

feature, hotfix

=

4

(terminal services/Citrix, NLB, Clustering, Role-based, Email integration, SSL)

(production, testing, UAT and Virtual Server)

5

(AD domains and networks)Mixed domains

– Internet facing

– Networks

– types: LAN

WAN

VPN

– attributes: bandwidth and latency

•

6

3 –

7

Application TierClient Tier Data Tier

Active Directory Domain

Controller /Internal DNS

Microsoft SQL Server§ Microsoft SQL Server

Reporting Services

Microsoft Dynamics CRM Server§ Microsoft Dynamics CRM Async Server

§ Microsoft Dynamics CRM API Server

Microsoft CRM E-mail Router

§ Microsoft Exchange Server

Microsoft Dynamics CRM

Web Client

Microsoft Dynamics CRM

for Outlook with Offline Access

Microsoft Dynamics CRM

for Outlook

1

8

http://www.consultcrm.co.uk/documents/mscrm4/Microsoft

DynamicsCRM_SuggestedHardware_250Users.pdf

2

9

http://blogs.msdn.com/crm/archive/2008/02/18/mscrm-v4-e-

mail-configuring-for-the-enterprise.aspx

3

10

Web

SDK

4

terminal server/Citrix Server

11

Suggested Hardware for Deployments of up to 500 Concurrent Users (

)

http://www.microsoft.com/downloads/details.aspx?familyid=3BF7ECDA-7EAF-4F1C-BBFE-CAE19BC8BB78&displaylang=en

Virtualization

– Virtual Server 2005

– Windows 2008 Hyper-V

– http://support.microsoft.com/kb/946600

12

UR

13

Update Rollup

, ,

Update Rollup

– Update Rollup 7 500 hotfix

– 2

– http://blogs.msdn.com/crm/archive/2009/01/23/microsoft-dynamics-crm-4-0-update-rollup-schedule.aspx

14

http://www.microsoft.com/dynamics/crm/using/customizing/11-supportedcustomizations.mspx

web

SDK APIs

CRM

15

CRM

CRM

16

(Client tier)

CRM

Office Outlook

Office Outlook with Offline Access

Internet Explorer ( Web Client )

(ping)

(cache expiration time)

17

(attributes):

(latency) <50ms

(bandwidth)

:

UR7 !!!

IE cache

CRM Web (15 days)

(WAN Accelerators)

Terminal Server/Citrix Server18

Outlook Clients

Email Router

UR7 !!!

19

CRM

CRM

(Async Service)

WebService

( CPU, )

ports

Plug-ins

SDK

20

Windows Server 2003

Performance and Scalabilityhttp://www.microsoft.com/windowsserver2003/evaluation/performance/default.mspx

Windows Server 2003 Solution Centerhttp://support.microsoft.com/?scid=ph;en-us;3198

Windows Server 2008

Performance Tuning Guidelines for Windows Server 2008http://www.microsoft.com/whdc/system/sysperf/Perf_tun_srv.mspx

Windows Server 2008 TechNet Centerhttp://technet.microsoft.com/en-us/windowsserver/2008/default.aspx

21

22

port : MaxUserPort

Windows Server 2003

1024 5000

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\MaxUserPort

Windows Server 2008 49152 65535

23

IIS

: Internet Information Services 6

Performance Tuning (IIS 6.0)http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/71490aae-f444-443c-8b2a-520c2961408e.mspx?mfr=true

IIS 6.0 Operations Guide (IIS 6.0)http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/dcec9cb2-9270-4ea5-8556-46528fea058d.mspx?mfr=true

Internet Information Services 7

IIS 7.0 Configuration Referencehttp://www.iis.net/ConfigReference

IIS 7.0 Output Cachinghttp://learn.iis.net/page.aspx/154/iis-7-output-caching/

IIS 7.0 Performance Discussionshttp://forums.iis.net/1050.aspx

24

Dynamics CRM

(role-based installation)

NLB

“ ” (watch out big queries!!)

– SDK: Retrieve AllColumns() ; FetchXMLConditionExpression

– Views/AdvancedFind/Reports: columns

– scheduled Reports

25

Group By

Scheduled Reports

(Business Intelligence)

TempDB

CRM

CRM

Microsoft SQL Server 2005/2008

Reporting Services

E-mail Router

(index)

26

27

KB 957871 AsyncOperationBase

http://support.microsoft.com/kb/957871/

KB 968755 AsyncOperationBase WorkflowLogBase

http://support.microsoft.com/kb/968755/

KB 968520

http://support.microsoft.com/kb/968520/

(index)

” ” !!!

index

28

Snapshot • ALTER DATABASE <myorg_mscrm>

SET ALLOW_SNAPSHOT_ISOLATION ONALTER DATABASE <myorg_mscrm>SET READ_COMMITTED_SNAPSHOT ON

MDOP (max degree of parallelism )=1

Database Mirroring

http://support.microsoft.com/kb/952278/

Database Clustering

29

• SQL 2008

(table and row compression

Sparse Columns)

CPU, , I/O

:

sp_estimate_data_compression_savings

ALTER TABLE T1 REBUILD WITH (DATA_COMPRESSION = PAGE);

ALTER INDEX IX_INDEX_1 ON T1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) ;

ALTER TABLE T1 ALTER COLUMN C4 ADD SPARSE ;

30

UR

CRM http://support.microsoft.com/kb/952934/

31

Update Rollup

SMS

GPO

UR7

32

KB 968520

http://support.microsoft.com/kb/968520/

Config DB, Org DB

33

34

http://blogs.technet.com/crmchina

35