Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Parallel Data Warehouse for OLTP Expand / Collapse
Author
Message
Posted Tuesday, April 9, 2013 12:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 7, 2014 6:22 AM
Points: 231, Visits: 721
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.
Post #1440157
Posted Tuesday, April 9, 2013 12:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
http://msdn.microsoft.com/en-us/library/ee730351.aspx

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1440161
Posted Thursday, April 11, 2013 3:06 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 4,400, Visits: 6,259
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 at GMail
Post #1441491
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse