Phoenix - Your AI AssistantSQL Server Index Strategy & Optimization
Delivery in
4 days
- Views 2
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will analyse your SQL Server database's index usage, identify missing indexes from DMV analysis and query workload review, implement a prioritised set of new indexes (covering indexes, filtered indexes, and columnstore indexes as appropriate), remove duplicate and unused indexes, and configure an automated index maintenance plan using Ola Hallengren's solution or SQL Server Agent jobs. Index management without a systematic approach creates index proliferation — tables with 30+ indexes that slow DML operations more than they benefit SELECT performance — while simultaneously missing the indexes that would provide the greatest query improvement.
The engagement covers sys.dm_db_missing_index_details analysis, Query Store workload review, duplicate index identification (exact and partial duplicates), index usage statistics review for unused index removal, new index implementation with fill factor configuration, and a SQL Server Agent job for weekly index reorganise and monthly rebuild based on fragmentation thresholds. An index maintenance document is included.
This service suits DBA teams and organisations whose SQL Server databases have never had a formal index review or whose index maintenance is inconsistent and causing performance problems.
The engagement covers sys.dm_db_missing_index_details analysis, Query Store workload review, duplicate index identification (exact and partial duplicates), index usage statistics review for unused index removal, new index implementation with fill factor configuration, and a SQL Server Agent job for weekly index reorganise and monthly rebuild based on fragmentation thresholds. An index maintenance document is included.
This service suits DBA teams and organisations whose SQL Server databases have never had a formal index review or whose index maintenance is inconsistent and causing performance problems.
What the Freelancer needs to start the work
Please provide SQL Server sysadmin access, your SQL Server version, the database(s) in scope, your maintenance window for index rebuild operations, and any known query workloads that are performing poorly.