How can we help you today? How can we help you today?
diophung
Activity overview Badges (0) Posts (2) Comments (2)

Comments

Sort by recent activity
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' / comments
  1. Community
  2. SQL Search
  3. SQL Search keep indexing in SQL 2014 Enterprise
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 a...
0 votes
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 / comments
  1. Community
  2. SQL Search
  3. SQL Search keep indexing in SQL 2014 Enterprise
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...
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1