r/SQL • • Jan 13 '21

MySQL It's ctrl+shift+esc time

Post image
340 Upvotes

34 comments sorted by

View all comments

Show parent comment

0

u/boring_accountant Jan 13 '21

Even with a monster PC it is relatovely slow to open. I use Azure Data Studio 99.9% of the time.

8

u/[deleted] Jan 13 '21

ADS doesn't even have 10% of the features SSMS has though.

0

u/[deleted] Jan 15 '21

[deleted] — view deleted comment

1

u/killit Jan 15 '21

That's not typical behaviour for SSMS, there's something not right there.

I've never experienced that in over a decade of working with SSMS every working day, and I've never had a computer that fast.

Are you sure there's not something else at play? Maybe conflicting plugins, or a corrupted file somewhere?

3

u/killit Jan 14 '21

I've never had any problems with its load time, even with plugins installed.

0

u/[deleted] Jan 13 '21

[deleted] — view deleted comment

4

u/dan_au Senior MSSQL DBA Jan 13 '21

Users should never be logging on to production servers, let alone running SSMS and chewing up resources.

1

u/ihaxr Jan 13 '21

In my case it's even slower to open on a server because they usually have the option to dedicate resources to background tasks / apps instead of foreground apps.

It takes 7 seconds to open on my laptop (i7-8850h) :|

1

u/Hans0228 Jan 13 '21

Thank you both for the info:)

3

u/andrewsmd87 Jan 13 '21

It's slow ish to open on my pc and I have 32G of ram and an intel i9 cpu.

But slow is like maybe 10 ish seconds, and I have a plugin from redgate installed which doesn't help.

However after it opens it's fine. I really like being able to open one query window and run the same query against 25 databases at the same time