Servers

    Microsoft Deploys Innovative Solution That Reports Near-Real-Time Data

    Language:
    English
    Microsoft deployed a mission-critical reporting solution that uses high-availability features in Microsoft SQL Server 2008 R2 to move data between online transaction processing systems, data marts, and a reporting server—instead of using the traditional extract, transform, and load operations. The highly scalable solution also splits each 250-gigabyte data mart based on the age of information.
    • Version:

      03/2013

      File Name:

      665NearRealTimeSQLReportingBCS.docx

      Date Published:

      3/14/2013

      File Size:

      374 KB

        Always looking for ways to improve efficiency, Microsoft wanted its executives and finance managers to be able to create near-real-time operating reports. The company also sought to increase system availability and cut costs. In 2011, Microsoft deployed a mission-critical reporting solution that uses high-availability features in Microsoft SQL Server 2008 R2 to move data between online transaction processing systems, data marts, and a reporting server—instead of using the traditional extract, transform, and load operations. The highly scalable solution also splits each 250-gigabyte data mart based on the age of information. As a result, data marts are updated every 7 minutes so that users can create accurate reports around the clock. The company has also increased data availability, reduced server footprint by 72 percent, sped system performance, and improved agility.
    • Supported Operating System

      Windows Server 2008 R2

    Popular downloads

    Loading your results, please wait...

    Free PC updates

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

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial