How can the performance of a large table in MSSQL be improved?

N

N

Nikita Rukavkov2015-10-06 15:41:38

SQL Server

Nikita Rukavkov, 2015-10-06 15:41:38

How can the performance of a large table in MSSQL be improved?

Good afternoon.
I observe a problem with the performance of the log table. The disk write queue has increased to 5. At the moment, there are 120,000,000 records in the table. The application does a bulk insert into the database.
What can be done programmatically?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

V

Victoria Kabishova2021-11-06 16:23:08

How to make sure SQL server is running? 1Reply

I

Igor Braduloff2018-08-28 11:58:11

How to call MS SQL stored procedure in Yii2? 0Reply

O

Oleg2021-11-11 10:30:41

How to link tables that are in different databases? 2Reply

I

iron eagle2016-04-08 23:25:08

Is it possible to do SELECT and INSERT in one query? 4Reply

D

Denis2016-04-10 13:39:00

How to move tables to another db using EF Code First? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question