Library
  1. Improving system performance
  2. SQL Server maintenance

SQL Server maintenance

SQL Server statistics that are out of date and tables and indexes that are significantly fragmented adversely affect system performance. You can monitor their condition and take steps to enhance their performance.
Note: This group of topics applies only to on-premises environments.
Related topics
  • Improving system performance
  • Statistical information
  • Updating statistics
  • Fragmentation information
  • Defragmenting indexes
  • Unneeded data