Sunday, May 18, 2014

SQL Server Management Studio Performance Issues

I work on VMWare Workstation 9.0 hosted Windows 2008 R2 Server. When I open Sql Server Management Studio, I experience sluggish performance while editing stored procedures. At that times I observe ssms.exe is hogging the cpu. Even a simple screen scroll causes %50 cpu spikes. I've tried patching SQL Server and VMWare but no avail. I also tried suggested solutions like disabling SVGA driver etc. As a solution, I logoff VMWare console and connect to server instance with remote desktop. No performance issue...

No comments:

Post a Comment