Post reply

Parallel Data Warehouse for OLTP

  • April 9, 2013 at 12:10 am

    #291931

    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.

  • April 9, 2013 at 12:20 am

    #1604674

    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

  • April 11, 2013 at 3:06 pm

    #1605785

    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