What Is The Difference Between SMP and MPP





Symmetric Multi ProcessorMassive Parallel Processor
1SMP stands for Symmetric Multi processorMPP stands for Massive parallel Processing
2In SMP every  processor share a single copy of the operating system (OS) In MPP each processor use its own operating system (OS) and memory. 
3SMP supports shared Architecture.MPP supports shared nothing Architecture
4SMP is the primary parallel architecture employed in serversMPP is the coordinated processing of a single task by multiple processors,
5SMP architecture is a tightly coupled multiprocessor system,In MPP each processor works on a different part of the task. 
6In SMP resources like bus, memory and an I/O system are common.Each processor has its own set of disks
7SMP processor share whole work between themEach node is responsible for processing only the rows on its own disk
8No Separate buffer pool or lock tables, All is sharedEach node maintains its own set of lock tables and buffer pool increasing usability of  in memory feature
9SMP grows by buying a bigger SystemScalability is easy by just adding racks , from few TB's to 6 peta byte
10SMP usually faces resource contention MPP is solution to resource contention
11To create Distributed Architecture complex design is required and can only achieve partially.MPP is designed to be Distributed Architecture 
12In – Memory feature provided by software is totally depending on amount of Ram and load.Data is Horizontally Partitioned with huge compression up to 40 x explores in-memory in best manners
13In SMP every CPU have its own cache either its dual or quad core but rest  all resources are sharedMPP processors  communicate between each other using some form of Messaging interface via an “Interconnect”





Scaling






Fundamental Difference









SQL Server 2012 Parallel Data Warehouse Architecture



SQL Server Parallel Data Warehouse Architecture

Recommended:What is MPP ( Massive Parallel Processor )

4 comments:
Write comments

Please do not enter spam links

Services

More Services