Parallel Data Warehouse for OLTP

  • Hi,

    Is Parallel Data Warehouse feature of SQL Server 2008 R2 targeted only for OLAP/BI impementations?

    Can we use it for hosting OLTP databases as well?

    Thanks.

  • http://msdn.microsoft.com/en-us/library/ee730351.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • praveen_vejandla (4/9/2013)


    Hi,

    Is Parallel Data Warehouse feature of SQL Server 2008 R2 targeted only for OLAP/BI impementations?

    Can we use it for hosting OLTP databases as well?

    Thanks.

    ABSOLUTELY NOT!! It is purpose built from the ground up for large scan aggregates.

    What you MAY want to check out is Hekaton. If you have seriously high transaction volumes MS may let you in on the TAP.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply