PLEASE NOTE: This tool leverages the SQL Management Objects to build the list of available SQL Servers. If you have named instances, ensure that a SQL Server Browser service is running
If you have the SQL Server Browser service running, or you are executing this tool on a default instance you should see the Authentication request dialog


PLEASE NOTE: This tool leverages the SQL Management Objects to build the list of available SQL Servers. If you have named instances, ensure that a SQL Server Browser service is running.

If you have the SQL Server Browser service running, or you are executing this tool on a default instance you should see the following Authentication request

Once you have provided authentication information you will be presented with the main screen where you should

  1. Select the database to process
  2. Decide the percentage of compression you would like, in order for an option to be displayed in the resuits (i.e. if you select 75, only compression that would result in a 75% savings will be displayed)
  3. Decide if you want Index Maintenance Ratios to be calculated

 

When the processing is complete (and this could take awhile in a database with a large number of objects) you will be presented with the results

You then have two options for saving the results of the analysis

  1. Save Results will save the entire contents of the results window to a comma separated value (CSV) file
  2. Create Script will create a Transact-SQL script that contains the appropriate syntax to implement those items selected

Last edited May 10, 2011 at 9:51 PM by majikbybob, version 4

Comments

bigpa Nov 13, 2013 at 9:31 AM 
Hello !

Firstly thanks for the tool :)

Secondly, just to propegate clarity the 'index maintenance ratio' is write/reads (sorry if this is in your docs but I missed it). Low means ideal candidate for compression, > zero means possibly avoid/consider fully first.

aaditya2000 Dec 15, 2011 at 6:36 PM 
Hello:

This is an excellent tool & thank you for provding this tool to SQL Community.

When i run this tool intermitently i am getting popup window saying "Divide by zero error encountered".

Any resolution to this error or latest version is greatly appreciated.

Thanks
Regards
Jay