General Issues faced in Performance

1. Queries Blockage.

2. Server Freezing.

3. High CPU Usage.

What should we have to check to increase performance.

1.Server Configuration

1.     Check hyper threading it should not present.

2.     Check Server Up time it should not more than 5.

2. MS-SQL Parameter

1.     Instance level.

Option Optimize for adhoc workload.

 Max degree of parallelism.

2.     Database level.

  Auto Growth ->  for database it should be 500 MB and for log it should be 10 %.

 Parameterization ot should be forced

 Auto update stats it should be true

3.     Check Fragmentation

   Rebuild.

   Reorganization.