Competition: What’s your favorite Redgate tool? Enter now.
Can SQL Prompt be causing blocking on db?
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.
0 · Share on Twitter