<p>I need to use best-suited cni for Dotnet core with SQL server(Same Network but different IP)  Kubernetes deployment.</p>

<p>It depends...</p>

<h1>TCP matters</h1>

<p>There is great article on performance of different CNI: <a href="https://itnext.io/benchmark-results-of-kubernetes-network-plugins-cni-over-10gbit-s-network-updated-april-2019-4a9886efe9c4" rel="nofollow noreferrer">Benchmark results of Kubernetes network plugins (CNI)</a></p>

<p>According to the charts, almost all CNI are best adapted to TCP.</p>

<p>See: TCP performance among CNI
<img src="https://miro.medium.com/max/2880/1*kuH6qDyQqqG7Nnex9PT4dg.png" alt="TCP performance among CNI"></p>

<p>Since you are pointed in comments that you are use MS SQL, so TCP is the main protocol for your case. Default MS SQL setup <a href="https://learn.microsoft.com/en-gb/sql/tools/configuration-manager/choosing-a-network-protocol?view=sql-server-2014" rel="nofollow noreferrer">uses TCP/IP protocol</a></p>

<p>So, among all CNI, according to their performance, you can choose almost any (except encrypted Clilium and encrypted WaveNet)  </p>

<h1>MTU matters too</h1>

<p>But, if you compare chart of performance with  CNIs auto-detect MTU option, you can see that only Cilium and Flannel remain champions (except for bare metal):</p>

<p><img src="https://miro.medium.com/max/2880/1*Nr--EbXRgNeHQzyLdFvinQ.png" alt="MTU auto-detected by CNIs"></p>

<h1>Does security matters?</h1>

<p>It depends. </p>

<p>Assuming that MS SQL provides the proper level of security out of the box, you can skip that part of recommendations.</p>

<p>If you decide that additional security level <strong>does</strong> matter for your case, you can refer this matrix:</p>

<p><img src="https://miro.medium.com/max/2400/1*8IXpUtCARPmm1W91nzWAxw.png" alt="Summary of security benchmark result"></p>

<h1>Conclusion</h1>

<p>So, for SQL,  if you choose from performance, then with a slight advantage you can choose Flannel or Cilium.
If security matters, then Cilium is better.</p>

<p>P.S. The answer below mentioned Calico.
As you can see on the TCP performance chart, Calico is the leader. <strong>But</strong> if you can setup correct MTU in your cloud.</p>
