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

Language:
English
This paper provides an overview, benchmark results, and recommendations for implementing selected Microsoft SQL Server 2008 R2 features that can improve the performance of Microsoft Dynamics CRM 4.0 and secure the CRM database.
  • Version:

    1.0

    File Name:

    Improving Microsoft Dynamics CRM 4.0 Performance and Securing Data with Microsoft SQL Server 2008 R2.pdf

    Date Published:

    10/4/2011

    File Size:

    331 KB

      Microsoft SQL Server® 2008 R2 contains a variety of features that, when implemented properly, can improve the performance of a Microsoft Dynamics® CRM 4.0 implementation and secure the data within that deployment. These Microsoft SQL Server 2008 features include:
      • Compression
      • Sparse Columns
      • Transparent Data Encryption
      • Backup Compression
      The MS CRM E2 team, working in conjunction with the Microsoft SQL Server team, recently completed a project that was designed to:
      1. Evaluate the new scenarios that these Microsoft SQL Server 2008 R2 features expose
      2. Measure the performance impact of implementing these features, both singly and in selected combinations
      This paper provides an overview of these Microsoft SQL Server 2008 features, together with benchmark results and recommendations for implementation.
  • Supported Operating System

    Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP

      • Adobe© Reader.


      1. To start the download, click Download, and then click Go.

      2. Do one of the following:


        • To start the installation immediately, click Open or Run this program from its current location.
        • To copy the download to your computer for installation at a later time, click Save or Save this program to disk.