Free SQL Server Optimization aids: Sqloptimize (original)

Primarily used to collect database operations for client servers, export-import to local analytics.

This tool does not modify your data and structure, it only reads the relevant data.

1) Tool software download

Http://files.cnblogs.com/files/dude/SqlOptimize.zip

2) SqlOptimize.exe.config

Configure the database to be collected

<?XML version= "1.0" encoding= "Utf-8"?><Configuration>    <Startup>             <supportedruntimeversion= "v2.0.50727"/></Startup>  <appSettings>    <AddKey= "ConnectionString"value= "Server =.; Database = names of your databases; User ID = sa; Password = 123456; Trusted_Connection = False; "/>  </appSettings>  </Configuration>

3) Running SqlOptimize.exe

Click the Quick Capture button, remember that the "Freeproccache" button does not click on the client's server and clears the execution plan cache.

4) Get the density of each column

Requires a large number of scan columns and is carefully executed

After the scan, the tree control is not refreshed, can be exported, and viewed after import.

5) finally

I have limited time, if there are errors please forgive us.

The tool software is tested in, SQLSERVER2008R2 and SqlServer2014.

Free SQL Server Optimization aids: Sqloptimize (original)