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

N

Nastya19202020-11-07 00:29:04

Is it possible to create an ER diagram of a sql database without third party tools? 1Reply

S

Senture2019-02-06 00:17:00

How to establish a relationship between tables? 2Reply

O

Oleg2019-02-06 17:46:13

How to get return of MS SQL procedure in PHP 7? 1Reply

U

unk1nD0002022-03-31 11:48:19

How can I increase the speed of the Costing Job operation? 1Reply

J

Julius_prog2022-04-16 21:48:46

Why does SQL Server 2019 install fail? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question