Home
  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 set of topics applies only to on-premises environments.
Related topics
  • Improving System Performance
  • Statistical information
  • Updating statistics
  • Fragmentation information
  • Defragmenting indexes
  • Unneeded data
  • Improving System Performance
    • Hardware
    • SQL Server settings
    • SQL Server maintenance
      • Statistical information
      • Updating statistics
      • Fragmentation information
      • Defragmenting indexes
      • Unneeded data
    • Centralized Vendor Metadata Database (CVMD)
    • Customizations
    • User actions
    • Replication
    • Locking and blocking
    • Windows tools
    • SQL Server stored procedures and commands
    • Printing barcode reports in PDF format
    • Troubleshooting timeout errors