SQL Search keep indexing in SQL 2014 Enterprise

Comments

• Dan B Redgate › Posts: 287 Gold 5

  February 27, 2017 6:10AM

  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

  0 · Share on Twitter
• diophung Posts: 6

  February 27, 2017 11:52PM

  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'
  
  

  0 · Share on Twitter
• Dan B Redgate › Posts: 287 Gold 5

  March 3, 2017 11:53AM

  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

  0 · Share on Twitter
• diophung Posts: 6

  March 22, 2017 2:57PM

  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

  0 · Share on Twitter
• rkretsch17 Posts: 6

  March 23, 2017 7:07PM

  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).

  0 · Share on Twitter
• Provis Posts: 1 New member

  May 24, 2017 11:25AM

  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.

  0 · Share on Twitter
• Jessica R Posts: 1,319 Rose Gold 4

  June 1, 2017 12:07AM

  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?

  
  

  0 · Share on Twitter
• LisaR Posts: 1 New member

  August 3, 2017 3:41PM

  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!

  1 · Share on Twitter
• agcData Posts: 1 New member

  January 24, 2018 9:52PM

  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

  0 · Share on Twitter
• Eddie D Redgate › Posts: 1,803 Rose Gold 5

  February 2, 2018 4:15PM

  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

  1 · Share on Twitter
• Alan_DPTYLTD Posts: 1 New member

  March 29, 2018 1:23AM

  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

  0 · Share on Twitter
• RichardL Posts: 417 Gold 4

  March 30, 2018 3:33PM

  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
  

  0 · Share on Twitter