DEV Community

Garry Xiao
Garry Xiao

Posted on

SQL Server huge data performance points

Based on the instance:

  1. Indexes,
  2. Query Hints,
  3. Data Partitioning:
  4. Computed Column to avoid unnecessary calculation:

Database replication is the technology to distribute data from the primary server to secondary servers. There are two main benefits of using SQL Server replication: 1. Using replication, we can get nearly real-time data which can be used for reporting purpose. 2. Define and schedule the replication. SQL Server supports three replication types: 1) Transactional Replication. 2) Snapshot Replication. 3) Merge Replication.SQL Server Database Replication:

The schedule is a timed logic calculation. A Job in the database side: Implementing a similar solution with Windows Service is also a choice.

Message Queuing
Messages can be queued and delivered later if the destination is unavailable or busy or need to consume a lot of time and external resources. Using the SQL Server Service Broker for Asynchronous Processing:

Caching is a popular mechanism used to accelerate response times and help applications scale while reducing the load on RDBMS systems, and save on resources. Using Redis with SQL Server:

Top comments (0)