Suppose your .NET application is experiencing high traffic, resulting in significant latency during database interactions. How would you diagnose and resolve this performance issue end-to-end? Cross Questions: – How would you ensure data consistency if you introduce caching or replication? – What load balancing strategies would you apply at both the application and database levels? – Can you explain your approach to database replication or sharding to handle heavy read/write loads?