Selecting database to search takes a long time

The dropdown box where I can select a database or databases to search within often takes very long to return results (over 10 minutes), during which time SSMS becomes unresponsive and locks up.  My organization has well over 1000 databases.  I'm using SQL Search on SSMS 2014 (12.0.4422.0).  A number of my coworkers have complained the same thing and have stopped using it.  If you do a simple select * from sys.databases, it returns result almost instantaneously and so I don't understand why populating the databases dropdown would take so long.  Can you please fix this problem?

In the past, it was already slow but starting about a couple of months ago, it became unbearable slow.  Thank you for your attention.


Sign In or Register to comment.