SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[12.0.191 Pro] SSMS 18.10 on Windows 11 freeze on startup
Goto page Previous  1, 2, 3
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[12.0.191 Pro] SSMS 18.10 on Windows 11 freeze on startup
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
I'm having the same hanging problem, but only 1 monitor. SQL Assistant 12.4.476 SSMS 19.2.56.2

If SQL Assistant is open it hangs before "connect to server".
If I close SQL Assistant it will get to Connect to Server, but then hang with the popup open (before clicking anything).
SQL Assistant closed and deleting C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Extensions\SQLAssistant allows it to connect and open Object Explorer, but New Query hangs.
SQL Assistant open but "Register SSMS Add-On" to NO, SSMS hangs before "connect to server"

Reinstalling SQL Assistant does not help.

Repaired SSMS, but Register SSMS Add-ON still no. Allowed SSMS to open with SQL Assistant open. Registering Add-On to Yes and Apply. SSMS hangs on open.
Mon Nov 27, 2023 11:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7904

Post Reply with quote
If you have Microsoft Process Explorer installed, can you please check the stack trace of the main SSMS thread when it hags to see what the tread is waiting for?
Mon Nov 27, 2023 8:09 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
Is this helpful?


Mon Nov 27, 2023 9:51 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7904

Post Reply with quote
Thank you! This is useful. May I ask you to reproduce it again and check if the call stack is similar each time? If the top two lines are ntdll.dll!TpCallbackIndependent -> SqlAssistPrefs.dll!__dbk_fcall_wrapper
Tue Nov 28, 2023 8:46 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
Yes, both have that call.




Tue Nov 28, 2023 9:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7904

Post Reply with quote
Thank you very much for the screenshots. We would need some time to analyze the call stack, this doesn't seem to be a trivial issue.
Tue Nov 28, 2023 9:43 am View user's profile Send private message
PosBr3n2084



Joined: 28 Jul 2023
Posts: 4
Country: Germany

Post Reply with quote
Is there any update on this issue? Thanks.
Tue Jan 16, 2024 3:21 am View user's profile Send private message
Frankie



Joined: 16 Feb 2022
Posts: 16
Country: Germany

Post Reply with quote
I would also be grateful if the problem was fixed.
Wed Jan 17, 2024 7:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7904

Post Reply with quote
We are working on it, and very much want to fix it as soon as possible. Don't have an ETA yet, the main issue is that we're unable to reproduce it on our test systems and so we unable to debug it. The stack traces shared with us so far don't show an obvious issue within SQL Assistant plugin, it's not active doing something while SSMS is freezing on startup. More stack traces can help us identify a common pattern. If you are able to reproduce this issue on demand, please work with us to identify the root cause. Please send your stack traces to the support account, we very much need them.
Wed Jan 17, 2024 9:31 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
You could try SSMS 19.3.
Fri Feb 16, 2024 11:02 am View user's profile Send private message
PosBr3n2084



Joined: 28 Jul 2023
Posts: 4
Country: Germany

Post Reply with quote
Strangly it was working for me for the last 6 months or so...today I got a Dell BIOS-Update Version 1.23.0 via Dell Command. And after the update, SSMS started to freeze again :/

The workaround is: change the custom scaling for the mainscreen in preferences of System/screen. Change it from 125% to 100% scaling. Then I can start SSMS. After that I can change the scaling back to 125% and it is working fine.
I will try SSMS 19.3
Wed Jul 10, 2024 8:59 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7904

Post Reply with quote
Super useful finding.
Is there an issue with any scaling factor other than 100% or with 125% only?
Wed Jul 10, 2024 11:35 am View user's profile Send private message
Frankie



Joined: 16 Feb 2022
Posts: 16
Country: Germany

Post Reply with quote
I have the same problems as PosBr3n2084. And also suddenly no problems over months.
But after reinstall my Windows 11 on my HP Laptop my problem is back.
My workaround is... change the mainscreen from the plugged in monitor (scaling 100%) to my Laptop monitor (scaling 125%). Which also works is to change scaling on my mainscreen.
I working on SSMS 19.3.
Mon Sep 02, 2024 2:20 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7904

Post Reply with quote
Thank you all for confirming. I think it's fair to say that issue is specific to multiple monitors with different screen resolution (DPI) and scaling factors. The issue seems to be specific to some combinations of hardware and software, and is occurring below the application code layer in internally used dependent libraries. The related support ticket SA#37276 is open and we're still testing different options looking for a good fix without side effects.
Mon Sep 02, 2024 9:59 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page Previous  1, 2, 3
Page 3 of 3

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.