CODEWITHSUNDEEP
sql-serverssmssql-server-2008
tuseau
tuseau

Reputation: 1393

SQL Server Management Studio hanging every few seconds

I'm using SQL Server 2008 R2. SSMS started intermittently hanging every 5 seconds or so today for no apparent reason. For example, I'm typing code and then the text editor stops updating for about 2 seconds, then suddenly catches up with what I'm typing. It's making work almost impossible. I've rebooted but I'm not sure what else to do since it's an SSMS issue - checking it in Task Manager and it's barely using any CPU, although it is using about 1.2 GB of memory.

Anyone experienced this before & know a possible fix?

Upvotes: 3

Views: 5376

Answers (1)

Chris Diver
Chris Diver

Reputation: 19812

Just some suggestions that might help.

You could try running SQL Profiler, and watch out for any lengthy calls to the database which might make it hang.

Have you tried turning off intellisense? Options -> Text Editor -> Transact-SQL -> IntelliSense -> Untick Enable IntelliSense

Upvotes: 5

Related Questions