Comments
Sort by recent activity
Mikeh has sent me his procedure and I can confirm I've reproduced extreme slowness followed by SSMS hanging.
It's now with the developers for further investigation. Thanks Mikeh! / comments
Mikeh has sent me his procedure and I can confirm I've reproduced extreme slowness followed by SSMS hanging.
It's now with the developers for further investigation. Thanks Mikeh!
Hi Richard,
Thanks for being so detailed. It's interesting that reinstalling .NET 4.0 seemed to help. The installer for SQL Prompt 5 does check for .NET 3.5 being present on the system -- did you not have 3.5 or later when you first used SQL Prompt 5? If so, it could be there's a bug somewhere in the detection code.
I think the "Microsoft .NET Framework 2.0.50727.4952" in SSMS is a bit of a red herring -- it's what my machine says on that About screen too, and I definitely have 3.5 installed and a working version of SQL Prompt 5. I think it's the version of the framework being used directly by SSMS.
Regards,
Paul / comments
Hi Richard,
Thanks for being so detailed. It's interesting that reinstalling .NET 4.0 seemed to help. The installer for SQL Prompt 5 does check for .NET 3.5 being present on the system -- did you...
Hi Richard,
Thanks for your details. When you open a query window, can you type at all if you wait for 30 seconds like Giggles220, or does SSMS completely hang?
Does this happen only on really big databases or the small ones too?
Before you open a query window, if you right-click on a database in Object Explorer and choose Find Invalid Objects, does it complete the operation or hang there too?
Regards,
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software / comments
Hi Richard,
Thanks for your details. When you open a query window, can you type at all if you wait for 30 seconds like Giggles220, or does SSMS completely hang?
Does this happen only on really big...
Hi Giggles220,
As discussed privately by email, your slowness issue seems to have gone now, maybe something to do with having a "phantom" Visual Studio open.
If any other users experience similar behaviour, please post here with as many details as you can, as we're still not really sure what caused the slowness in the first place.
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software / comments
Hi Giggles220,
As discussed privately by email, your slowness issue seems to have gone now, maybe something to do with having a "phantom" Visual Studio open.
If any other users experience similar b...
CodantiM wrote:
When do you think 5.1 will be released?
We're aiming to release SQL Prompt 5.1 in April.
Regards,
Paul / comments
CodantiM wrote:
When do you think 5.1 will be released?
We're aiming to release SQL Prompt 5.1 in April.
Regards,
Paul
Hi all,
Apologies for going dark on this one for so long.
The cause of the timeouts has now been identified. The Find Invalid Objects operation generates a query plan for each stored procedure in the database. If any one of these query plans takes more than 30 seconds then you will see the timeout error and no results.
For a quick fix, we will be increasing the timeout in SQL Prompt 5.1 to five minutes (unless popular opinion here prefers a different value). If you are impatient to use this feature then please email me at paul.stephenson@red-gate.com and I'll send you a private patch.
Regards,
Paul / comments
Hi all,
Apologies for going dark on this one for so long.
The cause of the timeouts has now been identified. The Find Invalid Objects operation generates a query plan for each stored procedure in ...
Thank you both for your comments. We're not sure yet why this timeout occurs, but we're looking into it.
Regards,
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software / comments
Thank you both for your comments. We're not sure yet why this timeout occurs, but we're looking into it.
Regards,
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software
Hi binarymechanic,
Do you have your keyboard scheme set to "SQL Server 2000"?
Referring to http://msdn.microsoft.com/en-us/library/ms174205.aspx , it looks like those keyboard settings make Ctrl+K turn on the execution plan. I guess no shortcuts beginning with Ctrl+K will be available under that scheme (just like the others that say "No equivalent" in the table on that page).
Regards,
Paul / comments
Hi binarymechanic,
Do you have your keyboard scheme set to "SQL Server 2000"?
Referring to http://msdn.microsoft.com/en-us/library/ms174205.aspx , it looks like those keyboard settings make Ctrl+K ...
Hi binarymechanic,
In what way does Ctrl+K Ctrl+Y not work? Does it just do nothing or is there an error? This is the first time we've had a report like this.
Regards,
Paul / comments
Hi binarymechanic,
In what way does Ctrl+K Ctrl+Y not work? Does it just do nothing or is there an error? This is the first time we've had a report like this.
Regards,
Paul
Many thanks for your report. We're looking into it.
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software / comments
Many thanks for your report. We're looking into it.
Paul Stephenson
SQL Prompt Project Manager
Red Gate Software