With SQL Server's default configuration, the system responds slowly (or even hung) in the production environment.

Please pay attention to and correctly configure the SQL Server instance and database parameters, the generalized configuration is recommended as follows:

1, the initial size of the data and log files are set to 10G and 2G respectively, are set to the fixed 200M size growth , not limit the maximum value;

2, the sever instance sets the maximum degree of parallelism to 1 (maximum not more than 4), or the parallel cost threshold is 20;

Without changing the default configuration of SQL Server, in a production environment where the system responds slowly (or even hung), the wait events for thread interaction caused by log expansion and parallel computing are as follows:

With SQL Server's default configuration, the system responds slowly (or even hung) in the production environment.