0
I'm using SSMS 2017 and have an issue that means as soon as I have even a small number of rows (10,000)the user experience lows down. I do have Redgate SQL tools installed, but colleagues have the same setup and do not see the issue.
If I have a large number of rows, 100K plus then the system is unusable and sometimes even hangs or crashes.
Has anyone else had this issue and more importantly have any suggested fixes. I have uninstalled and reinstalled the app and also checked memory usage which is low. The data is not that large really, just SSMS has a bit of a hissy fit. 1 row of data Any thoughts appreciated.
regards, Anthony
Anthony Blyth-Work
Posted 2019-03-27T13:54:52.277
Reputation: 1
I would start with a plane base install of ssms, and see if that works. record count isn't really a good indicator of data size either, 10k records can be a few mb, or potential several GB. Even 10K records is an awfully big result set to be working with, If you're extracting data, I would use the build in export tool before I tried to query the data, – Patrick – 2019-03-27T18:23:54.550
Thanks Patrick - I realise this is the case, which is why I provided an image of 1 row. My issue is I have a problem and my colleagues don't with the same data. I have done a clean install of SSMS 2018RC and it performs in the same way. Thanks for replying. – Anthony Blyth-Work – 2019-04-08T15:16:28.453
Are you and your colleagues running the same or at least similar hardware? Does ssms hang up, or your entire machine? – Patrick – 2019-04-08T15:18:51.930
Yes, we have similar hardware. SSMS does not usually hang, it just takes a long time between actions. (e.g selecting a new location in the query text, wait 15 seconds, type something in wait 15 seconds, move cursor wait 15 seconds, hide result pane, wait 15 seconds and then SSMS response goes back to normal until the results pane is displayed again... – Anthony Blyth-Work – 2019-04-10T15:02:51.750