Technet SQL Scripts

These seem to have appeared on Technet last year. Linking here and now as a memory jogger (because I intend to look at them further)....

Systems Scripts >

• Buffer Counts by Object and Index
  
• Determine CPU Resources Required for Optimization
  
• List Indexes With the Most Contention
  
• List Statements By Input/Output Usage
  
• Calculate Average Stalls
  
• List SQLOS Execution Model Information
  
• List Real-Time Tempdb Statements

Locking Scripts >

Analyze Index Statistics

- these are demos, how to reproduce locking behaviour >

• List Locks and Reads
  
• List Lock and Serializable Information
  
• Compare Locking and Repeatable Reads