SQL Search keep indexing in SQL 2014 Enterprise

• 
  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?

  Dan B February 27, 2017 06:10

  - 0 +
• 
  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 [1] INFO  RedGate.SQLSearch.Addin - Starting new SQLSearch 2 session
  27 Feb 2017 19:59:19.798 [1] INFO  RedGate.SQLSearch.Addin - Location C:ProgramDataRed GateSQL SearchActiveRedGate.SQLSearch.Addin.dll
  27 Feb 2017 19:59:19.798 [1] INFO  RedGate.SQLSearch.Addin - Assembly version: 2.4.0.1203
  27 Feb 2017 19:59:19.803 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] 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 [1] INFO  RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlWorkbench.Interfaces' 'V12.0.0.0' key='89-84-5D-CD-80-80-CC-91'
  
  

  diophung February 27, 2017 23:52

  - 0 +
• 
  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.

  Dan B March 03, 2017 11:53

  - 0 +
• 
  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

  diophung March 22, 2017 14:57

  - 0 +
• 
  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).

  rkretsch17 March 23, 2017 19:07

  - 0 +
• 
  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.

  Provis May 24, 2017 11:25

  - 0 +
• 
  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 R June 01, 2017 00:07

  - 0 +
• 
  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!

  LisaR August 03, 2017 15:41

  - 0 +
• 

  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

  agcData January 24, 2018 21:52

  - 0 +
• 
  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 D February 02, 2018 16:15

  - 0 +
• 
  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

  Alan_DPTYLTD March 29, 2018 01:23

  - 0 +
• 
  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. 

  RichardL March 30, 2018 15:33

  - 0 +

Add comment

Please sign in to leave a comment.