Home / Commands / Get-sqmMissingIndexes
Get-sqmMissingIndexes
Performance sqmSQLTool v1.8.2+
Retrieves missing index recommendations from the SQL Server DMV cache.

Examples

Get-sqmMissingIndexes -SqlInstance "SQL01"
Get-sqmMissingIndexes -SqlInstance "SQL01"
# Only high-impact recommendations
# Only high-impact recommendations
    Get-sqmMissingIndexes -SqlInstance "SQL01" -MinImpactScore 50 -MinSeeks 500
# Show top 10 and save as CSV
# Show top 10 and save as CSV
    Get-sqmMissingIndexes -SqlInstance "SQL01" -Top 10 -OutputPath "D:\Reports"
# Output CREATE INDEX statements directly
# Output CREATE INDEX statements directly
    Get-sqmMissingIndexes -SqlInstance "SQL01" -MinImpactScore 30 |
        Select-Object DatabaseName, TableName, ImpactScore, CreateIndexStatement |
        Format-List
← Previous Command
Get-sqmLongRunningQueries
Next Command →
Get-sqmPerfCounters