How can we help you today? How can we help you today?

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 3.1.7.2082 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.
Gibberish
0

Comments

4 comments

Sort by
  • Tianjiao_Li
    Hi @Gibberish

    Thanks for reporting this issue.

    Would you be able to share your log with us? I'll reach out to you by email.
    Tianjiao_Li
    0
  • Gibberish
    Hi @Tianjiao_Li

    Yes, please email me and I will reply with my logging.  I just captured one and I can tell you that I see the SQLSearch 3 Session started.  I was sitting here watching and my SSMS locked up for about 14 minutes.  The log file did not record anything during the time it was locked up, nor did it log completion of populating the search database dropdown.

    Gibberish
    0
  • Gibberish
    Hi @Tianjiao_Li
    I still have not received your email so I can send you the log file.  Please email me so I can send you the log.  
    Thanks,
    Kevin
    Gibberish
    0
  • Tianjiao_Li
    Hi @Gibberish

    So sorry that you didn't receive my email. I've just sent again.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.