Contents

System Information

• Hardware Information
  • Get manufacturer and model of the "iron", processor name string and frequency using T-SQL.
• Server Information
  • Overview report about relevant parameters of the SQL Server instance.
• Database Information
  • Report about all user databases: total MB, used MB.
• Object Information
  • Report about all user tables: name, rows, reserved KB, data KB, index_size KB, unused DB (based on parts of sp_spaceused).

Maintenance Tasks

• Database Maintenance
  • Generate a script for relocation of some database files (data and / or log).

Troubleshooting and Optimization

• Performance Optimization
  • SQL Server Best Practices from Microsoft
  • SQL Server Query Optimization from Microsoft
  • Performance Counter Guidance from SQL Server Premier Field Engineers in Microsoft UK

Where to Get the Scripts