Home / SQL Server / SQL Server Optimize Insert Performance In 5 Steps

SQL Server Optimize Insert Performance In 5 Steps

SQL Server Optimize Insert Performance In 5 Steps. What are the possible reasons of the slow table insert? What are ways to identify this bottleneck without the execution plan?

  • DROP ALL triggers and constraints on the table
  • DROP ALL indexes (except the ones that are needed by the insert)
  • Prevent page splits: make sure you use a clustered index that new records will be inserted at the end of the table. Use an IDENTITY column as the primary key.
  • Don’t leave empty space in the table: set the fill factor to 0 or 100 (same), reducing the number of pages that the data is spread across.
  • Reduce transaction log overhead: change the recovery model of the database to Simple

 

Check Also

Linked Server – Why and how use them!

A linked server is used to connect to another (remote) database or file (Xls, CVX) …

Geef een reactie

Het e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *