Microsoft SQL Server Management Studio causing system freeze

Posted by CRoshanLG on Server Fault See other posts from Server Fault or by CRoshanLG
Published on 2012-12-05T06:03:22Z Indexed on 2012/12/05 11:09 UTC
Read the original article Hit count: 338

Filed under:
|

I'm experiencing very slow response from MSSMS and it causes other applications to slow down. Specially Skype crashes after few seconds from opening MSSMS, showing an error called "Disk I/O Error". I'm regularly using few applications (Sublime text, MS Word, Firefox, Outlook, Skype and one or two other apps) simultaneously. The system works fine when MSSMS is not in use! But as soon as MSSMS is opened, all the apps start to freeze (MSSMS also responds very slow). This problem has been there for about a week now (I haven't installed any apps or haven't made any changes to the system during that time).

-- System Specifications --

  • Processor: Core i3 (3.1 GHz)
  • RAM: 4 GB
  • OS: Windows 7 Professional (64 bit)
  • Free space in C drive: ~ 100 GB

  • MS SQL Server 2008 R2

  • Microsoft SQL Server Management Studio version - 10.50.1600.1

I've tried to find a reason for this but there are no helpful information in the web! There are some solutions suggested (in forums and in Skype Support pages) for the Skypes' "Disk I/O Error", all of which I tried but does not solve the problem.

Has anyone faced the same senario? (and hopefully) knows a solution?



Systems Log

I don't have much knowledge in interpreting the System Log, but I think the Critical and Warnings are not helpful. But there are lots of Error logs which might be useful.

System Log Summary

In source Kernal-General there are few similar errors saying "An I/O operation initiated by the Registry failed unrecoverably.The Registry could not flush hive (file): <some file>"

In source atapi also there are few similar errors --> "The driver detected a controller error on \Device\Ide\IdePort0." (all errors has occurred in 'IdePort0')

In Application Error, there are several errors logged, and following is the latest one.

Application Error log

Both the Errors which has occurred today is similar (to this one). As it is from Ssms.exe, I guess this is relevant to the cause of problem. But as I said above I can't understand what it means!

© Server Fault or respective owner

Related posts about windows-7

Related posts about sql-server-2008