Analyzing a SQL Database

Analyzing Table Issues

• Tables that are HEAPS (without Clustered Indexes)
• Tables without Primary Keys
  
• Tables where which have identity columns, yet NO Primary Keys defined!
• Tables without NonClustered Indexes
• Foreign Keys without indexes
  
• Tables with Triggers

Indexing

• DTA - Database Tuning Advisor (use with care)
• Missing Indexes

Misc

• Deprecated column types
• Implicit Data Conversions
• Table Row Sizes

Operational Issues

• Table Statistics
• Index Fragmentation Status
• Page Splits