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

Activity overview

Latest activity by diophung

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
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
SQL Search 2.x keep indexing in MSSQL 2014 Enterprise
  1. Community
  2. SQL Search
Seem like the indexes are not saved (or remembered). Every time I open SQL Search 2 (v2.1,v2.2,v2.3) it keeps showing "Indexing..." messages. It took 20-30 secs to finish and it is quite annoying. ...
1 follower 1 comment 0 votes
SQL Search keep indexing in SQL 2014 Enterprise
  1. Community
  2. 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>AppData...
10 followers 12 comments 0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1