080160240320400480
PRJ lorem-query-optimizer
SRC sherbrooke
ENV production
VER 1.0.0
STATUS public
───────
LAYER sql-development
DB sql-server
ETL python
TOOL ssms
LANG t-sql
───────
NODES 4
← All Projects
Lorem Query Optimizer
A Python-based tool that connects to SQL Server, analyzes execution plans, identifies missing indexes, and generates optimization recommendations. Reduced average query time by 73% across 200+ stored procedures.
SQL ServerPythonSSMST-SQL
Connects to the target SQL Server instance, captures execution plans for the heaviest queries, and analyzes them for common anti-patterns: table scans, implicit conversions, and parameter sniffing issues.