January 24, 2019 at 6:16 am
Hello all,
In SSMS, in the object Explorer a right click on a table (context menu) takes ages. (SSMS not responding).
(This is using a RDP connection).
No problems with queries (in SSMS) etc.
Suggestions ?
Ben
January 24, 2019 at 8:02 am
This looks like the same problem :
No solutions, but some workarounds are suggested there,
Ben
January 25, 2019 at 6:36 am
The only suggestion I have is to make sure you're on the latest version of SSMS. They're updated completely independently from SQL Server now, so you need to patch them on a different schedule.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 30, 2019 at 8:45 am
A long shot, but SSMS seems to use msdb for a lot of its actions. I've seen bloated msdbs slow down SSMS considerably, even just expanding the db list. So make sure your msdb has been cleared of too-old history (however you choose to define "too old").
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply