Microsoft SQL Server Management Studio causing system freeze

sql-server-2008windows 7

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!

Best Answer

Your issue appears to be caused by a problem with your hard drive and/or controller.

Suggestions:

  1. Of course you have a full, current, backup and you've tested the restore process to make sure that it is actually usable. If not, back up your system immediately.

  2. Run a file system check including a scan for bad sectors. Keep in mind that bad blocks visible to the operating system on a contemporary hard drive are a very bad sign indicating that the drive should be replaced ASAP.

  3. Verify that all disk-related drivers (including RAID drivers and controller firmware) are up to date.

  4. Replace the drive/cable with known good parts, and restore from backup.

Related Topic