in by Vladimir Moldovanenko

Closed

as Not Reproducible Help for as Not Reproducible

Type:	Bug
ID:	776332
Opened:	1/11/2013 6:29:11 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

SSMS 2012 is slow and pauses/hangs when code is commented out in large procedure.
And I am tired of and frustrated with this issue. Others have suggested that this is a problem and in fact it is.

I can make it happen any time.

Details (expand)

English

SQL Server 2012 - Developer Edition

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Professional (SP1)

US English

Restore supplied db.
Open supplied script, find this line,
IF @wrhCode IS NOT NULL AND @locCode IS NOT NULL
BEGIN
Now type "/*" and try to move around. Watch CPU and memory. Try to move around, arrow up/down/mouse movements. For my co-worker, it does this when he removes "/*". It goes into this mode for a minute or so. Memory use drops and then grows again, repeating this process sometimes.
It seems that Intellisense is struggling to figure out things with large number of objects in memory.

SSMS freezes for few seconds, then again, and again, in total for a minute or more, consumes lots of CPU and memory. it makes it unbearable to work with it and very frustrating. that is why I am supplying you with private db so you can duplicate it against it.

no freezing

X64

File Name	Submitted By	Submitted On	File Size
SQLBackups.zip (restricted)	Vladimir Moldovanenko	1/11/2013	-

Posted by Sethu Srinivasan on 4/9/2013 at 4:43 PM

Please update latest Service packs and Cumulative updated for SQL 2012
http://blogs.msdn.com/b/sqlagent/archive/2012/12/05/latest-service-packs-and-cumulative-updates-for-sql-server.aspx

Thanks
Sethu Srinivasan [MSFT]

Posted by Microsoft on 1/25/2013 at 5:23 PM

Hi!, thanks for writing in to Microsoft.

We took a look at this bug and are unable to reproduce it in SSMS 2012 RTM. We followed your repro steps and attached the databases, opened the script file and typed the comment '/*' and moved around as you noted. SSMS and IntelliSense does not freeze and the CPU and memory consumption does not increase. We are closing this bug as ‘no repro’.

Regards,
Sanjay Nagamangalam, SQL Server Manageability

Microsoft