SQL Search is indexing your database - Every time I search

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

SQL Search is indexing your database - Every time I search

Postby a_j_k » Fri Jan 21, 2011 3:46 pm

Something has changed recently.

Previously SQL Search worked as expected, now whenever I do a search I get the "SQL Search is indexing your database. This will only happen once." message and it takes a very long time (many minutes) for SQL Search to index the database. Once it finishes I'm able to search.

The next time I try to search the same database, I get the same message and it goes through the indexing process again.

I'm running version 1.0.0.321 in Microsoft SQL Server Management Studio version 10.0.4000.0 running on 64-bit Windows 7.

Does anyone have any suggestions about why this would be happening or how to fix it?

Thanks.
Andy.
a_j_k
 
Posts: 2
Joined: Fri Jan 21, 2011 3:37 pm

Postby emoreau » Tue Jan 25, 2011 2:03 pm

same thing here! any fixes coming soon?
emoreau
 
Posts: 38
Joined: Tue May 23, 2006 6:48 pm

Postby tanya » Tue Jan 25, 2011 3:51 pm

Oops that is weird. I can email you both a new build so that you can check if that fixes your issue?

Thanks and apologies for any inconvenience this has caused.

Regards,
Tanya
tanya
 
Posts: 252
Joined: Mon Apr 30, 2007 8:29 pm

Postby nhustak » Wed Jan 26, 2011 3:39 pm

I've crashed four times today (sql search sent the log) - I wonder if this is related. Worst it's been - had just happened once a day or so.

The funny thing is that I haven't used it all today, so it's gotta be a background task tanking.

I LOVE sql search but for some reason this latest patch is unstable on my
system.

I work with a lot of systems over a VPN that isn't the best in the world. I would really like it to NEVER index them unless I ask it too.

Even better - an option to simply make indexing manual. I don't use it that often (but boy am I glad I have it when I need it) I would be fine with waiting for an indexing to get done before I search.
nhustak
 
Posts: 40
Joined: Tue May 09, 2006 8:06 pm

Postby tanya » Wed Jan 26, 2011 3:44 pm

That is not good... can you confirm the build number of your SQL Search please?
You can find this by clicking on Help - About.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd
tanya
 
Posts: 252
Joined: Mon Apr 30, 2007 8:29 pm

Postby a_j_k » Wed Jan 26, 2011 4:08 pm

I have not had the test version crash for me, but I've not used it that much. It still indexes the DB every time I access the same database. I uninstalled the old version and installed the new one.
a_j_k
 
Posts: 2
Joined: Fri Jan 21, 2011 3:37 pm

Postby scottdavidnelson » Fri Mar 11, 2011 7:04 pm

I also am experiencing this same issue, constant reindexing.

Has there been any thought given to changing the design of this tool so that it doesn't build an index at all, but rather just querying the system tables every time?

Idera SQL Search works this way and it's very fast, no indexing required.
scottdavidnelson
 
Posts: 2
Joined: Fri Jan 28, 2011 3:45 pm

Postby tobiasly » Fri Apr 08, 2011 2:05 pm

This is happening to me with version 1.0.0.340. I'm not even sure how I got this version since it's later than the version on the website (it was installed on my PC at work before I got here). Can you please give an update on this and whether I'm using the correct version?

BTW I also have a license for RedGate Developer Bundle if that matters.
tobiasly
 
Posts: 1
Joined: Fri Apr 08, 2011 2:03 pm

Postby spivey24 » Mon Apr 11, 2011 9:07 pm

I have a search stored procedure that scans all of syscomments for text like some param. It takes 4 seconds on a slow server with 1400 stored procedures. It would be nice if SQL Search degraded to a brute force scan if no index existed yet.

If I have a quick search I always use the search sproc instead because I will get results faster, but I really like being able to click on the object and have it highlight in the Object Explorer with SQL Search.
spivey24
 
Posts: 18
Joined: Tue Oct 17, 2006 3:16 am

Did Hellen Keller design SQL Search?

Postby joe12pack » Thu Nov 21, 2013 3:11 am

I can't tell if the thing is working or not. There's no search button. I just type in what I am looking for and it says it's indexing but it will just index only one time- even though it says that every time I search. Even if the searches are 10 minutes apart.

Sometimes it works. Sometimes it takes forever. It's faster for me to just search though the stored procs for what I am looking for one by one.

Someone needs to seriously redesign this thing. It's a POS.
joe12pack
 
Posts: 1
Joined: Thu Nov 21, 2013 3:03 am
Location: United States


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 1 guest