SQl SERVER-14.0.1000.169 & SSMS version -18.0

N Shashidhar Reddy

7y1.1k

when i click new query the window opening slowly and if i want check anything on the server through GUI method it is opening slowly like buffering...How can i resolve this issue..?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Subbarao A7y ago
Accepted answer
Hi

Only one server means then issue with server only.Try check from other system try to connect same server.if issue is same then server issue not with ssms
Subbarao A7y ago
Hi ,

Please check SQL server level settings, temp DB size, and your database storage space.

https://www.brentozar.com/sql/sql-server-performance-tuning/
https://www.brentozar.com/first-aid/
N Shashidhar Reddy7y ago
Yes.

SQL server has issue so how can i resolve this issue...??
N Shashidhar Reddy7y ago
Only one particuler server opening slowly another server doesn't have any issue with GUI method.....Is there any performance issue on that server...?How can i resolve this issue..?
Subbarao A7y ago
Hi

SSMS 18.0 has some issues you can update to the latest version. I have faced the ssmSSMS 18.0 not openings some time, with a flash of the screen only, not responding those issues are fixed with 18.1.