SSMS not responding; SQL Prompt is root cause. Why?
randyv
Posts: 166
Every once in a while, when I am connected to certain SQL Server instances, the SSMS will go into 'Not Responding' mode.
This seems to happen when I am writing T-SQL using temp tables. The more temp tables created, the slower and less responsive the query becomes until I cannot edit it at all and have to kill SSMS.
I noticed the other day when I restart SSMS, SQL Prompt takes a very long time doing whatever it does when opening a query window. So I turned it off on one of the troublesome queries and presto! Problem solved. So it was SQL Prompt causing SSMS to become unresponsive.
Any ideas why? I have grown dependent on SQL Prompt and do not want to turn it off.
This seems to happen when I am writing T-SQL using temp tables. The more temp tables created, the slower and less responsive the query becomes until I cannot edit it at all and have to kill SSMS.
I noticed the other day when I restart SSMS, SQL Prompt takes a very long time doing whatever it does when opening a query window. So I turned it off on one of the troublesome queries and presto! Problem solved. So it was SQL Prompt causing SSMS to become unresponsive.
Any ideas why? I have grown dependent on SQL Prompt and do not want to turn it off.
What we do in life echoes in eternity <><
Randy Volters
Randy Volters
Comments
This sounds very similar to the problems reported by mikeh on this forum.
Which version of SQL Prompt are you using? SQL Prompt 5.1.8 was released on 2 August and addressed some of these issues. If you're not on this version already, could you give it a try?
Regards,
Paul
Project Manager, Red Gate
Randy Volters