SQL Prompt freezes my Management Studio

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

SQL Prompt freezes my Management Studio

Postby geller_eugene » Wed Apr 01, 2009 5:52 pm

Terrific product, I used it all the time on my old computer (Windows Server 2003 x86), but then, after I upgraded (Windows Server 2008 x64), SQL Prompt just freezes my Management Studio for a while. It would unfreeze for a couple of seconds, and the only way for me to actually do some work is to disable it, but then I can't use it. I use Management Studio 2008, I just checked for updates and I am running the latest version of the product.

Here is the full version numbers of my tools:

Microsoft SQL Server Management Studio
10.0.1600.22 ((SQL_PreRelease).080709-1414 )

Microsoft Analysis Services Client Tools
2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )

Microsoft Data Access Components (MDAC)
6.0.6001.18000 (longhorn_rtm.080118-1840)

Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3074
Operating System 6.0.6001

SQL Prompt version 3.9.0.43


Here's the log:

01 Apr 2009 16:26:43,588 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
01 Apr 2009 16:39:12,564 [1] ERROR RedGate.SqlPrompt.Engine.LogService - Invalid second child for alias table. Was expecting an identifier (727) but found element of type 23.
01 Apr 2009 16:39:12,567 [1] ERROR RedGate.SqlPrompt.Engine.LogService - R
01 Apr 2009 16:39:12,589 [1] ERROR RedGate.SqlPrompt.Engine.LogService - at RedGate.SqlPrompt.Engine.Candidates.DerivedTableCandidate.a(SqlPromptEngine , cE , Element )
at RedGate.SqlPrompt.Engine.Candidates.DerivedTableCandidate..ctor(SqlPromptEngine engine, ISqlInfo parent, cE astMap, Element tableSubquery)
at ce.e(SqlPromptEngine , cE , Element )
01 Apr 2009 16:46:03,243 [22] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout)
at u.a()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()


Please let me know what I can do to let all my software coexist :)

Thank you.
geller_eugene
 
Posts: 4
Joined: Wed Apr 01, 2009 5:42 pm

Postby Linda Hawksworth » Tue Apr 07, 2009 10:34 am

Are you working over a VPN? We have a patch release to improve performance in these situations.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby geller_eugene » Tue Apr 07, 2009 7:44 pm

No, I am not working over a VPN. One other thing I did not mention is that my queries reference several different servers by aliases. When all our servers were SQL Server 2000 and I was on a 32-bit Windows Server 2003, it worked fine. Then I switched computers and now, in addition, one of the servers is actually a SQL Server 2005.
geller_eugene
 
Posts: 4
Joined: Wed Apr 01, 2009 5:42 pm

Postby Brian Donahue » Tue Apr 14, 2009 6:33 pm

I would suggest going into cache management and clearing everything out. It could be that there is some cunfusion between some cached databases if you are using aliases.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby geller_eugene » Tue Apr 14, 2009 6:49 pm

Brian,

Thank you for your reply. I enabled SQL Prompt, cleared cache, but it did not work. I had a query opened with aliases and SQL Server Management Studio started freezing almost instantly. Once I could get to the menu, I formatted a query and here's the log:

13 Apr 2009 17:15:49,971 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
13 Apr 2009 17:16:25,275 [27] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at Microsoft.VisualStudio.Package.LanguageService.ParseThread()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()


Management Studio kept locking up for a while so I had to disable SQL Prompt again.
geller_eugene
 
Posts: 4
Joined: Wed Apr 01, 2009 5:42 pm

Postby jerryhung » Fri Apr 17, 2009 5:05 pm

geller

Do you have anything else installed? SSMS Tools Pack or etc...
I'd uninstall SQL Prompt, restart, make sure SSMS works fine
re-install SQL Prompt again, and see how it works
Jerry Hung
DBA, MCITP
jerryhung
 
Posts: 113
Joined: Fri Dec 28, 2007 5:12 pm

Postby geller_eugene » Tue Jul 21, 2009 9:37 pm

I got some more information. The freeze only occurs when a 2000 server instance is trying to get to the 2005 server instance by alias which is not configured (I am opening last year's queries for the report and back then all the servers were SQL Server 2000).

It freezes for about 30 seconds, then I am able to go in to the menu and disable SQL Prompt, then it works.
geller_eugene
 
Posts: 4
Joined: Wed Apr 01, 2009 5:42 pm

Still not solved

Postby hrc1966 » Tue Jun 07, 2011 10:17 am

I found (a lot of) the same entries in my event log today. Will you inform us when the issue is fixed or how to we can fix it?

(US Windows 7, 64-bit)
hrc1966
 
Posts: 1
Joined: Tue Jun 07, 2011 9:56 am


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests