About database optimization acrobatics

As a record, some of the most basic checks:

1, the database log file is slow, will slow down the system speed, how to shrink the log needs attention;

2, the tempdb database is large, will slow down the system speed, the database restarts each time, the tempdb will be rebuilt, the tempdb allocated a large initial value of space, such as data file 300m, log file 50m;

3, through the management tool, performance Viewer, according to disk IO, two important indicators: PhysicalDisk in the Avg.Disk Read queue Length and Avg.Disk Write queue Length, If these two averages are greater than 0.5, you need to pay attention to the performance of disk IO;

4, through the SQLProfiler to track the SQL statement query efficiency;

5, to be continued;

About database optimization acrobatics