Database Repeatedly Indexed

• 
  Hi,
  
  This certainly shouldn't happen, unless you change databases while it's still indexing for the first time (incomplete indexes are discarded if they're cancelled part way through).
  
  If you look in C:\Docs & Settings\<username>\Local Settings\Application Data\Red Gate\SQL Search, there should be some log files - would it be possible to e-mail them to me at robert.chipperfield at red-gate.com, and I'll see if I can see what's going on?
  
  Thanks,
  Rob

  Robert C November 13, 2009 06:25

  - 0 +
• 
  Files sent as requested. BTW, I am running Windows 7 Ultimate x64.

  VisualDragon November 13, 2009 08:09

  - 0 +
• 
  Thanks Dave - received.
  
  There's nothing reported in the logs that would suggest a problem, and it shouldn't be Win7 either (one of the developer's machines was running Win7 x64 Enterprise as well).
  
  So just to confirm, if you do this:
  
  - Select a single DB in the Object Explorer
  - Open SQL Search. That should select that DB in the combo box
  - Type a couple of characters such that it begins searching
  - Wait until you get search results
  - Switch to a different DB
  - At this point it might start indexing the other DB, but should then give you search results
  - Switch back to the first DB
  - Here it should almost instantly return results.
  
  If it doesn't, does the progress bar say "searching" or "indexing"?
  
  Out of interest, if you've got multiple copies of SSMS open at once, could you try reproducing it with just the one copy running?
  
  Thanks,
  Rob

  Robert C November 13, 2009 08:17

  - 0 +
• 
  Playing with it again this morning it looks like the databases for which this happens are the ones that also have encrypted stored procedures. That's the most obvious difference between them.
  
  Hope that helps.

  VisualDragon November 13, 2009 08:18

  - 0 +
• 
  Followed steps provided with a single copy of SSMS open.
  
  The message says:
  "SQL Search is indexing your database. This will only happen once."
  
  When switching to another database that doesn't contain any encrypted objects the results are instantaneous. Switching back to a database with encrypted objects triggers the indexing again.
  
  Cheers,

  VisualDragon November 13, 2009 08:25

  - 0 +
• 
  Interesting - I'll have to investigate that one further, but it looks like the encrypted sprocs could be the guilty party. The intended behaviour is to ignore them (though the request to decrypt them is noted!), but possibly something's going wrong there...
  
  Thanks,
  Rob

  Robert C November 13, 2009 08:27

  - 0 +
• 
  I too have the problem that SQL Search is reindexing every day.
  
  I checked to find the log files from C:\Docs & Settings\<username>\Local Settings\Application Data\Red Gate\SQL Search and the folder does not exist. The only thing I have is 2 DLLs under Active and Source sub folders of the "All users" account.
  
  Also, where is the index persisted?

  emoreau November 17, 2009 10:06

  - 0 +

Add comment

Please sign in to leave a comment.