Hy, 

I'm using Sql Server Management Studio 2012 on my Win 7 x64 and in the last time it is slow, slow response when i try to edit row in table (right click and edit on table). If you know what to do i would appreciate it!

Best regards.

• Edited by markic0001 Friday, January 11, 2013 2:01 PM

Hi int,

Make sure the memory and processor are enough for the SQL Server. Please also apply the Windows 7 Service Pack 1.

Thanks.

Hi,

Check performance of a different db or sample/exmaple db available on same system. Seems like problem with DB/indexing.

Also apply latest service packs of SQL Server and Windows 7.

Use following query.

select * from sys.dm_os_wait_stats
order by wait_time_ms desc

you can check is to many wait stats

For  sys.dm_os_wait_stats results check following links

http://blog.sqlauthority.com/2011/02/03/sql-server-dmv-sys-dm_os_wait_stats-explanation-wait-type-day-3-of-28/

http://msdn.microsoft.com/en-us/library/ms179984.as

Hi int,

Any progress?

Open SQL Server Management Studio, in the Object Explorer, right-click the server and you could see the Memory and Processors. Have you assign the enough memory and processors to SQL Server?

Please use System Monitor to monitor the resource usage in SQL Server.

Monitoring Resource Usage (System Monitor): http://msdn.microsoft.com/en-us/library/ms191246(v=sql.105).aspx.

Thanks.

I experienced the same.

The problem was solved in SSMS by choosing Named pipes as network protocol in the options menu.