Business Solutions

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

    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:


      File Name:

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

      Date Published:


      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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Full apps across devices. Get Office 365 Business.
    Office 365 Business
    Get full apps across devices.
    Buy now