Setup No Drive Indexing - SQL-FineBuild/Common GitHub Wiki
| Previous Setup Volume Shares | Manual Install | Setup SQL Folder Structure Next |
|---|
FineBuild can disable indexing of drive contents.
The indexing of drive contents can speed up the process of finding a file. However, it is very rare that files will need to be searched on a database server, and the processing time taken by Windows to maintain the drive index would be better used to process end-user database queries.
It is therefore recommended that drive contents indexing is disabled for database servers.
FineBuild No Drive Indexing Processing
Processing of No Drive Indexing relates to Process Id 1FA in the FineBuild1Preparation script, and is controlled by the parameter below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupNoDriveIndex: | Yes | No | No |
| SQL2017 | /SetupNoDriveIndex: | Yes | No | No |
| SQL2016 | /SetupNoDriveIndex: | Yes | No | No |
| SQL2014 | /SetupNoDriveIndex: | Yes | No | No |
| SQL2012 | /SetupNoDriveIndex: | Yes | No | No |
| SQL2008R2 | /SetupShares: | Yes | Yes | Yes |
| SQL2008 | /SetupNoDriveIndex: | Yes | No | No |
| SQL2005 | /SetupNoDriveIndex: | Yes | No | No |
SQL FineBuild will start a CMD window to apply the attribute changes needed to disable drive indexing. This process may take a few minutes to complete. If you open the CMD window you will see each file name as it is processed, and some files may not have their index attribute changed due to lack of permissions. This behaviour is normal, and the disable drive indexing process will eventually complete.
Manual Setup No Drive Indexing Processing
The following steps show what you would have to do to setup No Drive Indexing manually. FineBuild does all of this work for you automatically.
-
Right-click on each drive letter and select Properties
-
Unless you are installing Express Edition, clear the checkbox Allow Indexing Service… and click on Apply
-
Click on OK to confirm disabling content indexing
-
If you get a message similar to that shown below, click Ignore All
A CMD window will open showing the progress of changing the attributes. A number of files will show as Access Denied but these can be ignored
Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements
| Previous Setup Volume Shares | Top | Setup SQL Folder Structure Next |
|---|