Page 1 of 1

Index Manager - fix with CMD

Posted: Sun 13 Feb 2022 09:40
by naji
I'm looking for fix index using CMD , but it's show me indexed list without fix ..
I have a lot of databases, and i need to fix all databases index with script, how I can fix all indexes automatically from CMD?


Command: indexmanager.com /analyzeindex /connection:"Data Source=********;Initial Catalog=myDbName;User ID=********;Password=********;" /database:myDbName /rebuildthreshold:30 /reorganizethreshold:10 /minindexsize:100 /tempdbsort:On

Analyzing SQL Indexes through the Command Line:
https://docs.devart.com/index-manager/m ... h-cmd.html

I have license for Index Manager , and it's activated on my SSMS SQL Server

Re: Index Manager - fix with CMD

Posted: Tue 15 Feb 2022 13:28
by alexa
We will review this issue and will answer you as soon as possible.

Re: Index Manager - fix with CMD

Posted: Wed 16 Feb 2022 10:28
by alexa
To analyze and generate rebuild script in file, you have to use - /fixindexes

To view all available switches, type:
indexmanager.com /analyzeindex /?

We will amend the docs, though.