Free SQL Scripts for Managing and Monitoring SQL Server 2005

I came across these scripts on the

Microsoft TechNet Script Centre

Microsoft SQL Server 2005

• 
  Buffer Cache
  • 
    Retrieve Buffer Counts by Object and Index
• 
  CPU and Optimization
  • 
    Determine CPU Resources Required for Optimization
  • 
    Retrieve Parallel Statements With the Highest Worker Time
  • 
    Retrieve Statements with the Highest Plan Re-Use Counts
  • Retrieve
    Statements with the Lowest Plan Re-Use Counts
• 
  Indexes and Indexing

  • 
    Analyze Index Statistics

  • 
    Create/Truncate an Indexstats Table
  • 
    Determine Index Cost Benefits
  • 
    Identify Missing Indexes
  • 
    List Indexes With the Most Contention
  • 
    Retrieve Index Statistics
  • 
    Retrieve Index Usage Statistics
  • 
    Retrieve Indexes Not Used Since the Last Recycle Time
  • 
    Retrieve Object and Index Fragmentation Information
  • 
    Retrieve Tables, Indexes, Files, and File Groups Information
• 
  Input/Output

  • 
    Calculate Average Stalls

  • 
    List Queries That Could Benefit From an Index
  • 
    List Rarely-Used Indexes
  • 
    List Statements By Input/Output Usage
• 
  Performance (General)
  • 
    List Cached Plans Where Worker Time Exceeds Elapsed Time
  • 
    List Currently-Executing Parallel Plans
  • 
    List Recompiled Statements
  • 
    List Runnable Queues
  • 
    List Statements With the Highest Average CPU Time
  • 
    List Statements with the Highest Execution Counts
  • 
    List Top Wait Types for a Workload
• 
  Processor Cache

  • 
    Compare Single-Use and Re-Used Plans

  • 
    List Statements By Plan Re-Use Count
• 
  SQL Text

  • 
    Retrieve a SQL Statement with a Specified .SQL_Handle

  • 
    Retrieve SQL Text and XML Plans
• 
  SQLOS

  • 
    Compare Signal Waits and Resource Waits

  • 
    List Currently-Executing Statements
  • 
    List Scheduler Wait List Information
  • 
    List Schedulers, Workers, and Runnable Queues
  • 
    List Session and Scheduler ID Information
  • 
    List SQLOS Execution Model Information
  • 
    List Statements from a Specified Waiter List
• 
  Tempdb

  • 
    List Real Time Tempdb Task Usage

  • 
    List Real-Time Tempdb Statements

• 
  Transactions and Logging
  • 
    Compare Locking and Repeatable Reads
  • 
    Configure a Block Condition
  • 
    Handle a Block Condition
  • 
    List Lock and Serializable Information
  • 
    List Locks and Reads
  • 
    List Locks and Repeatable Reads
  • 
    List Real-Time Blocker and Waiter Statements
  • 
    Report Blocker and Waiter SQL Statements
• 
  Waitstats

• 
  Retrieve Waiter List Information

• 
  Retrieve Waitstat Snapshots