Post reply

Is there a tool to automate SQL tuning and review?

  • August 6, 2020 at 3:25 am

    #3777708

    I am looking for a tool that reviews and tunes SQL queries automatically. Does Microsoft or a 3rd party vendor have such a tool? Ideally such a tools could be used to automate this process fully. If it could perform standards checking that would be even better. Any ideas?

  • August 6, 2020 at 3:58 am

    #3777717

    I'm not aware of anything that does that, and certainly not well.

    For a SQL instance managed by Azure, there is some index tuning automatically done, but it's pretty limited.

    You can use policy-based management in SQL Server to enforce many rules.  That's a very broad subject, so naturally you'd have to research it and study it much more to use it.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply