Mostly when you work with single Sql Server or monolithic application , there is a less worry about consistency model. Once you start working in distributed system you need to consider consistency models. 
Data-Centric Consistency Models
<ol>
<li>Strict Consistency model</li>
<li>Sequential Consistency</li>
<li>Linearizability</li>
<li>Causal Consistency</li>
<li>FIFO Consistency</li>
<li>Weak consistency</li>
<li>Release Consistency</li>
<li>Entry Consistency</li>
<li>Processor consistency</li>
<li>General consistency</li>
<li>Local consistency</li>
<li>Cache consistency</li>
</ol>
Client-Centric Consistency Models
<ol>
<li>Eventual Consistency</li>
<li>Monotonic Reads Consistency</li>
<li>Monotonic Writes</li>
<li>Read Your Writes</li>
<li>Writes Follow Reads</li>
</ol>

Mostly when you work with single Sql Server or monolithic application , there is a less worry about consistency model. Once you start working in distributed system you need to consider consistency models. 

**Data-Centric Consistency Models**
1. Strict Consistency model
2. Sequential Consistency
3. Linearizability
4. Causal Consistency
5. FIFO Consistency
6. Weak consistency
7. Release Consistency
8. Entry Consistency
9. Processor consistency
10. General consistency
11. Local consistency
12. Cache consistency

**Client-Centric Consistency Models**
1. Eventual Consistency
2. Monotonic Reads Consistency
3. Monotonic Writes
4. Read Your Writes
5. Writes Follow Reads

Info Desk: How many types consistency models are there?

Professionally Technical Architect. Love software design and development, explore and learn new technology, mentoring and sharing knowledge. Craving for performance, optimization and automation.
