The auto-complete hint-list or SQL Server Management Studio, itself, ‘freezes’ when using auto-complete

Applies to
ApexSQL Complete

This article explains what to do when the ApexSQL Complete hint-list requires too much time to load or occasionally “freezes” SQL Server Management Studio.


If Windows 8 or Windows 10 is the OS and Windows defender is turned on, it may negative impact ApexSQL Complete hint-list performance. Windows defender checks the ApexSQL Complete hint-list prior to loading which degrades the performance of the hint list and sometimes prevents it from loading at all.


To resolve this, the ApexSQL folder from this location C:\Users\<user_name>\AppData\Local\ must be excluded from Windows defender scanning.

Go to Settings and click the Update & security option:

On the left side of the Settings window, click the Window Defender tab:

 Under the Exclusions section, click the Add an exclusion option:

Find the ApexSQL folder in this location: C:\Users\<user_name>\AppData\Local\ and press the Exclude this folder button:

The ApexSQL folder should now be placed in the list under the Exclude a folder section: