Git Product home page Git Product logo

sqlindexmanager's Introduction

SQL Index Manager

This tool lets you quickly and easily find out the status of your indexes and discover which databases need maintenance.
You can do maintenance through the UI, or generate a T-SQL script to run in SSMS.

Key Features

  • An incredibly fast describe engine
  • Multiple databases scanning
  • Advice on rebuilding or reorganizing
  • Analysis of fragmentation results
  • Configurable fragmentation thresholds
  • One-click maintenance
  • Command-line automation
  • Automatic T-SQL script generation
  • Columnstore maintenance support
  • Collecting missing indexes
  • Drop or disable unused indexes
  • Index rebuild with compression options
  • Export of scan results into Excel, CSV, HTML and text files
  • Support for any editions of SQL Server 2008+ and Azure
  • And a lot of other improvements :)

Latest Version

You can download .zip file with the latest build of the master branch from Releases

Future Plans

  • Improvements in command-line automation
  • Detect duplicate and unused indexes
  • Statistics maintenance

Topics

SQL Index Manager โ€“ Free GUI Tool for Index Maintenance on SQL Server and Azure

Screenshots

SQL Index Manager SQL Index Manager SQL Index Manager

Command Line

/connection "Data Source=HOMEPC\SQL_2017;Integrated Security=True;User ID=HOMEPC\PC"

This switch is used to specify connection string

/databases "AdventureWorks2017;AdventureWorks2012;msdb"

This switch is used to specify databases to manage indexes in

/connectiontimeout 30

This switch is used to specify connection timeout in seconds. Overrides value specified in the connection string

/commandtimeout 120

This switch is used to specify command execution timeout in seconds. Overrides default option (90 seconds)

/online

This switch is used to rebuild indexes with online option

/ignoreheap

This switch is used to ignore any heaps during maintenance

/ignorecolumnstore

This switch is used to ignore any columnstore indexes during maintenance

/ignorebtree

This switch is used to ignore any b-tree indexes during maintenance

/maxdop 8

Configure the max degree of parallelism during maintenance. Overrides server option

/reorganizethreshold 15

Specifies reorganize the fragmentation threshold in %. Overrides default option (15%)

/rebuildthreshold 30

Specifies rebuild the fragmentation threshold in %. Overrides default option (30%)

/minindexsize 32

This switch is used to specify the minimum index size in MB. Overrides global option (6 MB)

/predescribesize 128

This switch is used to specify the predescribe index size in MB. Overrides global option (256 MB)

/maxindexsize 8096

This switch is used to specify the maximun index size in MB. Overrides global option (8 GB)

Thanks

Ievgenii Vasyliev - for his help in the development and implementation of the command line

sqlindexmanager's People

Contributors

sergiisyrovatchenko avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.