Menu

Open Source AI-enabled Index Tuning Stored Proc for SQL Server

#sql#redditsql#azure#database#indexes
Reading 0:00
15s threshold

Disclosure: I’m the founder of AI SQL Tuner LLC.

Azure SQL Database has had automatic indexing for years. If you run SQL Server on-premises, on a VM in another cloud, or on Azure SQL Managed Instance, you’ve been managing indexes by hand. I built aisqltuner-index-tuner to fill that gap, and it’s free and MIT-licensed. It was inspired by Brent Ozar's post on Microsoft’s 2006 AutoIndex.sql prototype: I'm Probably Not Supposed To Show You Microsoft's Auto-Indexing Tool. - Brent Ozar Unlimited® .

It’s a stored procedure that collects index diagnostics from your database, sends them to your own Azure OpenAI deployment , and stores the recommendations in a table.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.