SQL Search keep indexing in SQL 2014 Enterprise

diophungdiophung Posts: 6
edited March 23, 2017 7:07PM in SQL Search
Every time when I click on SQL Search icon, I see the "Indexing..." message. It took 20-30 seconds and quite annoying.
It used to work before.

I double checked the folder C:Users<user name>AppDataLocalRed GateSQLSearch 2Indexes and all the indexes are still there.
I also try removing /reinstalling SQL Search (v2.1, v2.2, v2.3) multiple times, none works so far.

What went wrong and how to fix it?
Tagged:

Comments

  • Hi Diophung,

    Does this occur after you search for an item or before? If your able to search are you searching for all objects and databases or for just one of each?
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Hi Dan,

    It happens before I search for item.

    I am able to search for all databases once the indexing finish.

    But next time I open SQL Search, the indexing appears again. It seems like the indexes are never used for subsequent search.

    Here is the log:
    27 Feb 2017 19:59:19.791 &#91;1&#93; INFO  RedGate.SQLSearch.Addin - Starting new SQLSearch 2 session
    27 Feb 2017 19:59:19.798 &#91;1&#93; INFO  RedGate.SQLSearch.Addin - Location C:ProgramDataRed GateSQL SearchActiveRedGate.SQLSearch.Addin.dll
    27 Feb 2017 19:59:19.798 &#91;1&#93; INFO  RedGate.SQLSearch.Addin - Assembly version: 2.4.0.1203
    27 Feb 2017 19:59:19.803 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'mscorlib' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    27 Feb 2017 19:59:19.805 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Platform.AppDomainManager' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.806 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    27 Feb 2017 19:59:19.806 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Windows.Forms' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    27 Feb 2017 19:59:19.806 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Drawing' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.806 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.10.0' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.806 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Core' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    27 Feb 2017 19:59:19.806 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.OLE.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'WindowsBase' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'PresentationFramework' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'PresentationCore' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Xaml' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.UI.Internal' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.807 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop.8.0' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop.9.0' 'V9.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Platform.WindowManagement' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Design' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.ViewManager' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'EnvDTE' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'EnvDTE80' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.808 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.UI.Internal.resources' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'PresentationFramework.Aero2' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Platform.WindowManagement.resources' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Settings' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Configuration' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Xml' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.CommonIDE' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.CallHierarchy.Package.Implementation' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.809 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.QuickSearch.Package' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.810 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'VsDebugPresentationPackage' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.810 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Debugger.PdtDebug' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.810 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Debugger.PdtDebug.resources' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    27 Feb 2017 19:59:19.810 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.AnalysisServices.Project' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.810 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.DataWarehouse.VsIntegration' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.810 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.MultiServerMgmtVS' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.PbmUiPackage' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.RegisteredServersUI' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.Reports' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio.Actions' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio.Explorer' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.811 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio.ResourceMonitor' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.812 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.XEventUI' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.812 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SQLEditors' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.812 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlWorkbenchProject' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.812 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.DataTransformationServices.VsIntegration' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.812 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlPackageBase' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.812 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.Controls' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.813 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.SString' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.813 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.SqlTDiagM' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.813 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Instapi' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.813 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SDK.SqlStudio' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    27 Feb 2017 19:59:19.813 &#91;1&#93; INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlWorkbench.Interfaces' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    
    
  • Hi diophung,

    There is an existing bug open for this under reference SDI-683. At this point, I can't provide an ETA on when this will be fixed. I will keep this post updated with any information that I receive on this.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Hi Dan,

    Do we have any update for this ? This bug basically reduce the usefulness of SQL Search by at least 50%.

    Without the fast cache and instant result, the time waiting for SQL Search to finish indexing is more than searching for it manually.

    Dio
  • I recommend upgrading to SSMS 2016 (it has a lot of improved features) and make sure you only connect to one server at a time. That seems to fix this slow indexing and zero search results bug (until they get it fixed).
  • ProvisProvis Posts: 1 New member
    We have the same problem with SSMS 2016. It's also very annoying, that SQL Search keeps recreating the indexes for all databases on an instance, even if they were never searched. I've got 3 GB of index files on my disk. Can't use it at the moment.
  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hi all,

    We don't yet have an update on this, I'm sorry to say, but we will still post here once we do.

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • LisaRLisaR Posts: 1 New member
    I am having the same problem, but what is even worse is that even though I have only one database selected in the database dropdown list, once the indexing starts, the database selection list switches to "All databases" automatically. So then it starts to index every database, which would probably take hours. The only thing I can do to stop it at this point is to close SSMS.

    Agree with a previous post that this issue has made this tool practically unusable!
  • agcDataagcData Posts: 1 New member
    Jessica R wrote: »
    Hi all,

    We don't yet have an update on this, I'm sorry to say, but we will still post here once we do.

    Any update here?
    It's been close to a year since this was first brought up
  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    Following the problem reported in this post and this SQL Search Forum Post:
    https://forum.red-gate.com/discussion/82285/getting-false-results-in-3-0-x#latest

    Colleagues in the development team responsible for SQL Search are investigating the problems and are planning to build a new Indexing module to replace the one currently in the tool.

    I will update when the new version of SQL Search becomes available that fixes the issues reported to us.
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Alan_DPTYLTDAlan_DPTYLTD Posts: 1 New member
    Hi,
    I was also having this issue and seem to have successfully negated it by blind luck.
    After indexing had completed, I disconnected from the server in the object explorer and then reconnected. Immediately the search results appeared that had not previously worked and the re-indexing has not occurred since.
    I hope this helps your dev team debug this.
    Regards
    Alan
  • RichardLRichardL Posts: 417 Gold 4
    Hi @Alan_DPTYLTD

    Thanks for your post. 

    Please note that a newer version was released yesterday and is available for download below. 

    ftp://support.red-gate.com/patches/SQLSearch/29Mar2018/SQLSearch_3.1.2.1997.exe

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
Sign In or Register to comment.