Index

Find-DbaDbDisabledIndex

Jason Squires, sqlnotnull.com

Find-DbaDbDisabledIndex View Source Jason Squires, sqlnotnull.com Windows, Linux, macOS Synopsis Identifies disabled indexes across SQL Server databases Description Scans SQL Server databases to locate indexes that have been disabled, returning detailed information including database, schema, table, and index names. Disabled indexes consume storage space but aren’t maintained during data modifications, making them candidates for cleanup or re-enabling. This is useful for database maintenance, performance troubleshooting, and identifying indexes that were disabled during bulk operations but never re-enabled.

Find-DbaDbDuplicateIndex

Claudio Silva (@ClaudioESSilva)

Find-DbaDbDuplicateIndex View Source Claudio Silva (@ClaudioESSilva) Windows, Linux, macOS Synopsis Identifies duplicate and overlapping indexes that waste storage space and degrade insert performance Description Scans database tables to identify indexes that have identical or overlapping column structures, which consume unnecessary storage space and slow down insert, update, and delete operations. Duplicate indexes have exactly the same key columns, included columns, and filter conditions, while overlapping indexes share some key columns but differ in others.

Find-DbaDbUnusedIndex

Aaron Nelson (@SQLvariant), SQLvariant.com

Find-DbaDbUnusedIndex View Source Aaron Nelson (@SQLvariant), SQLvariant.com Windows, Linux, macOS Synopsis Identifies database indexes with low usage statistics that may be candidates for removal Description Analyzes index usage statistics from sys.dm_db_index_usage_stats to identify indexes with minimal activity that consume storage space and slow down data modifications without providing query performance benefits. This function helps DBAs optimize database performance by finding indexes that are rarely or never used, so you can safely remove them to reduce maintenance overhead, speed up INSERT/UPDATE/DELETE operations, and free up disk space.

Get-DbaHelpIndex

Nic Cain, sirsql.net

Get-DbaHelpIndex View Source Nic Cain, sirsql.net Windows, Linux, macOS Synopsis Retrieves comprehensive index and statistics information from SQL Server databases for performance analysis and optimization. Description This function queries SQL Server DMVs to return detailed index and statistics information for performance analysis, index maintenance planning, and identifying optimization opportunities. You can target all indexes in a database or focus on a specific table to analyze index usage patterns, sizes, and fragmentation levels.