Home Dashboard Directory Help
Search

SSMS 2012 freezes/locks when large SP SQL block commented out/in by Vladimir Moldovanenko


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 776332
Opened: 1/11/2013 6:29:11 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
Sign in to post a comment.
Posted by Robert Heinig II on 7/5/2013 at 7:05 AM
SSMS has been unnecessarily slow in fringe cases for years - e.g. agent history timing out when an equivalent select on the msdm sysjobhistory* responds in seconds... Or try editing around a script using a virtual table built old-style using union all and having thousands of rows - freezes every other keystroke... Or try using the "new" activity monitor compared to querying dm views or or or... This should not detract from the fact that it is mostly an admirably potent and reliable freeware tool.
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
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
SQLBackups.zip (restricted) 1/11/2013 -