SQL Server Performance Tuning | Dataford Interview Questions

Tell me about a time you performed performance tuning for SQL Server under production constraints. Implement a function that selects a subset of proposed tuning actions with maximum total benefit without exceeding the available budget. Return names in original order; break ties by choosing fewer actions, then the lexicographically smaller index sequence.

Constraints

0 <= candidates.length <= 200
0 <= budget <= 10000
Each candidate has a unique string name
1 <= candidates[i]["cost"] <= 10000
0 <= candidates[i]["benefit"] <= 100000
Each candidate may be selected at most once
The returned names must appear in their original candidate order

Function Signature

def select_tuning_actions(candidates, budget):

Your question is SQL Server Performance Tuning. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Constraints

0 <= candidates.length <= 200
0 <= budget <= 10000
Each candidate has a unique string name
1 <= candidates[i]["cost"] <= 10000
0 <= candidates[i]["benefit"] <= 100000
Each candidate may be selected at most once
The returned names must appear in their original candidate order

Function Signature

def select_tuning_actions(candidates, budget):

Your question is SQL Server Performance Tuning. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.