Competition: What’s your favorite Redgate tool? Enter now.

Can SQL Prompt be causing blocking on db?

LenkaLenka Posts: 3
edited February 2, 2017 11:16AM in SQL Prompt
I was just told by one of our DBAs that “RedGate Intelligence”, I’m sure he means SQL Prompts is casing locking in production. I have not looked into exactly how it works, but just the fact that we you have “Refresh suggestions” in order to pull in the latest database changes would tell me that it’s not live querying the database schema to pull this information and should not be causing any locking. I’m worried that they will try to keep us from using SQL Prompt (he was hinting to that). Could someone please let me know if it is accurate and if SQL Prompt could actually be causing locking and point me to a place in the documentation that would clarify this.

Comments

  • Eddie DEddie D Posts: 1,688 Rose Gold 5
    Hi, thank you for your post into the forum and sorry that you have encountered a problem.

    What version of SQL Prompt are you using?

    Version of SSMS, you are using?

    Do by any chance also have SQL Search installed? This is another Redgate product that plugs-in to SSMS. If you do have SQL Search installed, what version is installed?

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Eddie DEddie D Posts: 1,688 Rose Gold 5
    Hi, in case it is actually SQL Search causing the blocking you have reported in this forum topic.

    SQL Search V2.3.8.1089 has just been made available. This new version contains a bug fix for the indexing problem on startup of SSMS, which maybe related to the blocking problem you reported.
    To download SQL Serach V2.3.8.1089, please use this link to download:
    ftp://support.red-gate.com/patches/SQLS ... Search.zip

    Please do upgrade SQL Search and confirm that the problem is resolved in your environment. Or to inform us that you are still experiencing the problem.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.